Querying SAS Data Sets Using the SAS Structured Query Language

• Calculate new columns in a query.
• Eliminate duplicate rows from being returned in query results.
• Subset data in a query.
• Order data in a query.
• Summarize data in a query using functions.
• Use subqueries to subset data based on values in other tables.
• Combine data sets in a query.
• Assign an alias to a table.
• Compare solving a problem using the SQL procedure versus using traditional SAS programming.
• Create and use an SQL view.
• Update and delete data values in a table.

Designing, Writing and Debugging Macro-based Systems Using the SAS Macro Facility

• Understand the default flow (i.e. tokenization, compilation and execution) of a SAS program and how the macro processor affects program flow.
• Create and reference macro variables.
• Display the value of a macro variable.
• Use macro functions.
• Combine macro variable references with text.
• Create macro variables during the execution of the DATA step.
• Reference macro variables indirectly.
• Obtain a macro variable value during execution.
• Define and call macro programs.
• Use macro level statements to control processing within a macro program.
• Process code conditionally within a macro program.
• Describe where macro variables and their values are stored.

Using Advanced Programming Techniques for Improving SAS Program Efficiency

• Use basic techniques for improving the performance of BASE SAS programs.
• Reduce the space required to store values in SAS data sets.
• Create and use DATA step views.
• Create and maintain simple and composite indexes.
• Understand when the SAS System uses an index to retrieve data and when it does not.
• Use the MODIFY statement in a DATA step.
• Use statements, such as REPLACE, in conjunction with the MODIFY statement, to control the update process.
• Use automatic variables to monitor the process of updating a SAS data set.
• Create, use, document, and store permanent formats.
• Use control data sets in the FORMAT procedure.
• Load an array from a SAS data set.
• Understand the concept of a SAS sort flag and how it is used.
• Use various sort options.
• Use appropriate options to handle data that is grouped but not sorted.
• Compare variables and observations from two data sets.

Designing and Creating Text Reports

• Select the appropriate SAS report-writing tool.
• Organize data to simplify report writing.
• Understand the components of COLUMN and DEFINE statements.
• Use stored report definitions to produce REPORT procedure output.
• Modify the default ordering sequence in reports produced using the REPORT procedure.
• Compute new columns in the REPORT procedure.
• Create subtotals using the REPORT procedure.
• Create grand totals using the REPORT procedure.
• Control the appearance of report pages using system options and REPORT procedure options.
• Add titles and footnotes to reports.
• Understand column usage types in the report procedure.
• Stack column data in reports.
• Span multiple columns with one column header.
• Use a column alias in the REPORT procedure.
• Create one-, two-, and three-dimensional tables using the TABULATE procedure.
• Enhance reports created using the TABULATE procedure.
• Calculate percentages, using the TABULATE procedure.
• Produce simple reports using FILE and PUT statements in the DATA step.
• Produce multiline reports.
• Calculate summary statistics using the MEANS procedure and the SUMMARY procedure.
• Produce multilevel summary reports using the MEANS procedure.

Designing and Creating Graphic Reports Using SAS/GRAPH Software

• Enhance graphics output.
• Plot values of two variables on an X and Y axis plot.
• Apply interpolation techniques to plots.
• Add a second vertical axis to plots.
• Customize plot axes.
• Control features of default legends using LEGEND statements.
• Set and modify graphics options.
• Produce bar, block, and pie charts.
• Group and subgroup charts.
• Label sections in pie charts.
• Understand the structure of map data sets.
• Understand the relationship between map data sets and response data sets.
• Produce choropleth, block, and prism maps.
• Understand how Annotate data sets store graphics commands.
• Draw and label reference lines.
• Annotate output from SAS/GRAPH procedures using different frames of reference.
• Label the lines on plots using the ANNOTATE facility.