Advanced SAS

Advanced SAS : Test Content

Accessing Data Using SQL

  • Generate detail reports by working with a single table or joining tables using PROC SQL and the appropriate options
  • Generate summary reports by working with a single table or joining tables using PROC SQL and the appropriate options
  • Construct sub queries within a PROC SQL step
  • Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques
  • Access Dictionary Tables using the SQL procedure
  • Demonstrate 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 defining and calling macros using the SAS Macro Language
  • Understand the use of macro functions
  • Recognize various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log

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, integrity constraints and audit trails
  • Reduce the space required to store SAS data sets and numeric variables within SAS data sets by using compression techniques, length statements or DATA step views
  • Develop efficient 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 efficient 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)


Ravi Mandal

“Definiteness of purpose is the starting point of all achievement.”



No comments yet.

Leave a Reply sitworld team.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: