SAS Programming
Course Length - 3 Days
After the course, attendees will have a thorough knowledge of the internals of the SAS System, be able to write advanced DATA Steps, combine and transpose SAS files and deal with many kinds of data manipulation problems, as well as being able to write more efficient programs.
Public Course price:
£1,050.00 plus VAT per delegate
View On-Site course prices »
SAS Programming Public Course Dates
Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!
Audience
SAS users who wish to extend their knowledge of SAS software. The course builds on the tools and techniques taught in the SAS Fundamentals course.
Prerequisites
Ideally the delegate will have attended the SAS Fundamentals course or have an equivalent level of competence. This course is a significant step up from the SAS Fundamentals training course; we recommend that attendees have three to six months of regular SAS programming experience to gain the most benefit from this course.
IMPORTANT: The SAS Programming course builds on the fundamental concepts of SAS and assumes the delegate already has a working knowledge of the following:
- Using either the SAS Display Manager, SAS Enterprise Guide or SAS Studio to:
- Develop and submit programs
- Debug messages in the log
- View output generated
- Understand the structure of a SAS data set including column attributes such as column type and length
- Write DATA step code to:
- Perform conditional processing using the IF statement
- Create variables using expressions and functions
- Read data using the SET statement
- Import data using the INFILE and INPUT statements
- Merge data using the MERGE statement
- Familiarity with the following SAS procedures:
- Proc SORT
- Proc PRINT
- Proc FORMAT
- Use data set options such as KEEP, DROP, RENAME and WHERE
- Use of BY-group processing (i.e. using a BY statement in DATA and Proc steps)
- Understand when and how to use Informats and Formats
- Understand how to work with SAS Dates and Times
If you would like further advise on whether this course is suitable for you please call +44 (0) 1993 848010.
Topics
P1 DATA Step Internals
- Course Objectives
- Refresher on SAS and the SAS Environment
- DATA Step Processing Logic
- Compilation and Execution
- Workshop Session
P2 Data Handling
- Functions and Call Routines
- Formatting Techniques
- Workshop Session
P3 DATA Step Processing
- Data Set Options
- Select Statements
- Loops
- Arrays
- Workshop Session
P4 Reading Data from SAS Files
- SET Applications
- Sampling from SAS Data Files (Optional)
- Workshop Session
P5 Combining SAS Files
- MERGE Applications
- UPDATE Applications
- Table Lookups
- Workshop Session
P6 Summarising and Transposing Data
- Data Summarisation
- Data Transposition
- DATA Step Methods (Optional)
- Workshop Session
P7 Reading From/Writing to External Files
- Review of Simple Methods
- Format Modifiers
- Files with Delimiters
- Importing Data from Microsoft Excel
- Read, Test and Read in the Rest (Optional)
- Reading Files with a Constant Number of Repeating Groups (Optional)
- Creating Reports using DATA_NULL_Steps (Optional)
- Workshop Session
P8 Managing the SAS Environment
- Data Libraries
- Password Protection (Optional)
- System Options and Utilities
- Autoexec Files
- Batch Processing
- Workshop Session
P9 Advanced Reading of External Files (Optional)
- Reading Variable Length Data
- Reading with Transposition
- Reading Files with a Varying Number of Repeating Groups
- Further Examples of Using the Trailing @ Sign
- Multiple Input Files
- Workshop Session