Job Meter = High
Fast Track Fundamentals and Programming
30 Hours
Online Instructor-led Training
USD 1399 (About this Course
This course serves as a, fast tracking attendees who have little to no knowledge of SAS to the point where they can confidently work with the SAS programming language. After the course, attendees will be able to use SAS software to read their data, manage, manipulate and summarise their data, solve problems, use conditional logic, use iterative processing, create formats, combine files and produce tables and listings of data.
-------------------------------------------------------------
Target Audience
This fast track course is designed for Computer Users who wish to learn the key principles of programming within the SAS System.
-------------------------------------------------------------
-------------------------------------------------------------
Target Audience
This fast track course is designed for Computer Users who wish to learn the key principles of programming within the SAS System.
-------------------------------------------------------------
Fast Track Fundamentals and Programming
Course Details & Curriculum
FT1 Introduction
- What is SAS?
- SAS Software and Solutions
- Introduction to the SAS Environment
- Using the Display Manager System (DMS)
- Using SAS Enterprise Guide
- Working with SAS Programs in Enterprise Guide
- Using SAS Studio
- SAS System Walkthrough
FT2 Writing SAS Programs
- Working with SAS Data Libraries
- Accessing Other Data Sources
- Structure of a SAS Program
- Rules of the SAS Language
- Table Structures
- Interpreting the SAS Log
- Cancelling Submitted Code
FT3 Importing Data into SAS
- Reading Data
- Importing Text Files
- Accessing PC Files and Databases
- Using the Import/Export Wizards
FT4 Programming with the DATA Step
- Creating SAS Variables
- Reading SAS Data Sets
- Conditional Processing
- Creating Multiple Subsets
- Missing Values
- Common DATA Step Statements
FT5 Manipulating Data
- WHERE, KEEP, DROP & RENAME Options and Statements
- Functions
- Accumulators
FT6 Formats and Labels
- Formats and Informats
- Proc FORMAT
- Labels
FT7 Combining SAS Tables
- Sorting
- Appending
- Merging
FT8 Dates and Times
- How Dates and Times are Stored in SAS
- Date and Time Informats / Formats
- Date and Time Functions
FT9 Data Analysis
- Proc FREQ
- Proc MEANS
FT10 Summarising and Transposing Data
- Data Summarisation
- Data Transposition
FT11 Reporting
- Controlling SAS
- Titles and Footnotes
- Proc PRINT
FT12 Enhancing Output Using ODS
- Introduction to ODS
- Capturing SAS Output
- Styles in ODS
- DATA Step Processing Logic
- Compilation & Execution
FT13 Data Handling
- Functions and Call Routines
- Formatting Techniques
FT14 DATA Step Processing
- > DATA Step Options
- > Select Statements
- > Loops
- > Arrays
FT15 Reading Data From SAS Files
- SET Applications
FT16 Combining SAS Files
- MERGE Applications
- UPDATE Application
- Table Lookups
FT17 Reading From/Writing to External Files
- Review of Simple Methods
- Format Modifiers
- Files with Delimiters
- Importing Data from Microsoft Excel