+44 7459 302492
support@uplatz.com
Job Meter = High
SAS Programming
30 Hours
Online Instructor-led Training
GBP 2000
About this Course
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.
--------------------------------------------------
Target 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.
--------------------------------------------------
--------------------------------------------------
Target 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.
--------------------------------------------------
SAS Programming
Course Details & Curriculum
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
