Before attending this course, you should have knowledge equivalent to having completed the SAS Programming 1: Essentials and SAS Programmierung 2: Datenmanagement courses. Specifically, you should be able to do the following: Write simple SQL queries using the SELECT statement.Read from and write to SAS tables using a DATA step.Use DATA step programming statements, including IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO. Use SAS data set options, including DROP=, KEEP=, and OBS=. Use character functions, including SUBSTR, SCAN, and UPCASE. Read subsets from tables using the WHERE statement. Create and use SAS date values and constants. Use Base SAS procedures such as SORT, PRINT, CONTENTS, MEANS, and FREQ.