– Use of FORMATTED and LIST input

– Reading raw data files with the INPUT statement

– Managing variable-length records with INFILE options

– Combining SAS datasets through concatenation and interleaving

– Merging data sets one-to-one and one-to-many

– Accessing Excel workbooks with SAS/ACCESS engines

– Creating temporary and permanent SAS data sets

– Using the DATA step to create datasets from text and existing SAS data

– Working with SAS date values and formats

– Exporting data to standard and comma-delimited raw data files

– Controlling observations and variables with DROP and KEEP statements

– Investigating SAS data libraries with LIBNAME statements

– Sorting observations and conditional execution of SAS statements

– Generating list reports using the PRINT procedure

– Modifying PROC PRINT behavior with statements and options

– Creating frequency tables with PROC FREQ

– Enhancing frequency tables with formats and options

– Calculating summary statistics and multilevel summaries with PROC MEANS

– Enhancing reports through user-defined formats, titles, and footnotes

– Generating reports using ODS statements for HTML, PDF, RTF, and LISTING files

– Identifying and resolving programming logic errors

– Using PUTLOG statements for debugging in the Data Step

– Recognizing and correcting syntax errors

– Diagnosing syntax errors using the SAS log

– Investigating and resolving data errors with PROC FREQ, PROC MEANS, and the SAS log

– Utilizing the SAS system option ERRORS=n for error messages