SAS Base Programming Exam
Accessing Data
? Use FORMATTED, LIST and COLUMN input to read raw data files
? Use INFILE statement options to control processing when reading raw data files
? Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
? Combine SAS data sets using the DATA step
Creating Data Structures
? Create temporary and permanent SAS data sets
? Create and manipulate SAS date values
? Use DATA Step statements to export data to standard and comma delimited raw data files
? Control which observations and variables in a SAS data set are processed and output Managing Data
? Investigate SAS data libraries using base SAS utility procedures
? Sort observations in a S AS data set
? Conditionally execute SAS statements
? Use assignment statements in the DATA step
? Modify variable attributes using options and statements in the DATA step
? Accumulate sub-totals and totals using DATA step statements
? Use SAS functions to manipulate character data, numeric data, and SAS date values ? Use SAS functions to convert character data to numeric and vice versa
? Process data using DO LOOPS
? Process data using SAS arrays
Generating Reports
? Generate list reports using the PRINT an d REPORT procedures
? Generate summary reports and frequency tables using base SAS procedures
? Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options
? Generate HTML reports using O DS statements
Handling Errors
? Identify and resolve programming logic errors
? Recognize and correct syntax errors
? Examine and resolve data errors