This two day workshop uses the “HANDS-ON’ approach to teach application programmers or users the advanced concepts of the SAS language.

Application Programmers, Analysts interested in gaining an understanding of Advanced SAS and users with an intermediate knowledge of SAS.

Upon successful completion of this course, the student will be able to:

• Use Advanced SAS data features
• Use SAS built-in functions
• Use PROC SUMMARY, PROC TABULATE, and PROC RANK
• Use PROC APPEND and PROC COMPARE
• Use SAS Debugging Tools
• Use SAS Macro Language
• Use SAS Arrays

• Basic SAS Review
• SAS Data Files
• PROC APPEND
• PROC COMPARE
• SAS Debugging Tools
• Built-in Functions
• PROC SUMMARY
• PROC TABULATE
• PROC RANK
• LINK and GO TO Statements
• ARRAYS
• DO Statement
• Macro Language
• Creating Permanent Formats
• The Trailing @
• Retrieving Random Samples