Advanced Programming Techniques

·         Demonstrate advanced data set processing techniques such as updating master data sets, transposing data, combining/merging data, sampling data, using generation data sets, honesty constraints and audit trails

·         Reduce the space required to store SAS data sets and numeric variables within SAS data sets by using density techniques, length statements or DATA step views

·         Develop capable programs by using advanced programming techniques such as permanent formats and array processing

·         Use SAS System options and SAS data set options for controlling memory usage

·         Control the processing of variables and observations in the DATA step

·         Create sorted or indexed data in order to avoid unnecessary sorts, eliminate duplicate data and to provide more well-organized data access and retrieval

·         Use PROC DATASETS to demonstrate advanced programming skills (e.g. renaming columns, displaying metadata, creating indexes, creating integrity constraints, creating audit trails)

Accessing Data Using SQL

·         Generate detail information by working with a single table or union tables using PROC SQL and the suitable options

·         Generate summary reports by working with a single table or union tables using PROC SQL and the suitable options

·         Construct sub queries within a PROC SQL step

·         Compare solving a problem using the SQL procedure against using traditional SAS programming techniques

·         Access Dictionary Tables using the SQL procedure

·         display advanced PROC SQL skills by creating and updating tables, updating data values, working with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints, SQL views and SET operators

Macro Processing

·         Creating and using user-defined and automatic macro variables within the SAS Macro Language

·         Automate programs by crucial and calling macros using the SAS Macro Language

·         Understand the use of macro functions

·         make out various system options that are existing for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log