SAS Combo (Essentials & Beyond the Basics) Course
Course Features:
Live Instructor Teaching
Certificate of Completion
Courseware: Print
Free 6 Month Online Retake
Hands-On Learning?: Yes
Software Lab Included?: Yes
(May require trial or license)
Delivery Methods:
Live Online
Individuals and Groups
@ Your Location
Onsite for Teams
Group Teams
@ Your Organization
This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.
For team training, we can teach onsite at your office or private live online.
Course Overview
Enroll in both levels of our instructor-led SAS Programming classes and save $300. This course package includes:
Register Early: Registration Deadline is 2 Weeks Prior to Class Start.
Course Notes
Course Combo Refund Policy: Once payment is received, there are no refunds on instructor-led course bundles, due to a discount being given. However, you may reschedule any of the included classes if needed.
Knowledge Prerequisites
Before attending this course, you should have experience in the following areas:
- concepts such as file and variable
- accessing data files on your operating system
- programming logic concepts such as IF/THEN
No prior SAS experience is needed.
Related Certifications
SAS® Certified Base Programmer for SAS® 9 Certification
Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.
Course Topics
SAS Programming Essentials (Days 1 - 3)
Chapter 1: Getting StartedThe SAS Language
SAS Data Sets
DATA and PROC Steps
Built-in Loop
SAS Data Libraries
Viewing Data Sets in the View Table
Chapter 2: Getting Data into SAS
Methods for Inputting Data
Entering Data with Viewtable
CARDS and DATALINES
Reading space delimited files
Reading data arranged in columns
Reading data not in standard format
Informats
Mixing input styles
Reading messy raw data
Reading multiple lines per observation
Reading multiple observations per line
Reading part of a data file
Controlling input with options
Reading delimited files with the DATA step
Reading delimited and Excel files with PROC IMPORT
Temporary versus Permanent Data Sets
Listing contents of the SAS Data Set
Dynamic Data Exchange (DDE)
Chapter 3: Working With Your Data
Creating and Redefining Variables
Using SAS Character Functions
Using SAS Numeric Functions
Using SAS Date Functions
Subsetting your data
Using IF-THEN Statements
Chapter 4: Sorting, Printing and Summarizing your data
Using SAS Procedures
Subsetting in Procedures with the WHERE clause
Sorting with PROC SORT
Printing with PROC PRINT
Changing the Appearance of Printed Values with Formats
Creating Custom Formats
Calculating basic descriptive statistics
Calculating frequency tables
Producing reports with PROC TABULATE
Chapter 5: Enhancing Your Output
Concepts of the Output Delivery System
Creating Text Output
Creating HTML Output
Creating RTF Output
Creating PDF Output
Chapter 6: Combining SAS Data Sets
Combining Data Sets Using a One-to-One Match Merge
Combining Data Sets Using a One-to-Many Match Merge
SAS Programming 2: Beyond the Basics (Days 4 - 5)
IntroductionCourse logistics
Course overview
SAS syntax review
Summarizing Data
Creating an accumulating total variable
Accumulating totals for a group of data
Processing Data Iteratively
DO-loop processing
SAS array processing
Using SAS arrays
Restructuring a Data Set
Rotating data with the DATA step
Using the TRANSPOSE procedure
Combining SAS Data Sets
Using IN= option with match-merging
Writing Flexible Code with the SAS Macro Facility
Using macro variables for text substitution
Writing simple macro definitions
Supplying parameters
Using Conditional Logic in macro code
Create macro variables using the DATA step
Debugging macro errors
Exporting Your Data
Understanding file types to export
Using the EXPORT Wizard
Using PROC EXPORT
Debugging Your SAS Programs
Common errors and how to fix them.
Using the DEBUG option
Using the PUTLOG statement
Less common errors and how to fix them
Other Languages
PROC SQL
Related SAS Information:
Software Training
Courses by Location
- Cyber Security Courses in Houston
- Cyber Security Certifications Chicago
- Cyber Security Classes Atlanta
- Cyber Security Certifications NYC
- Project Management Courses New York
- PMP Training Dallas Texas
- Cyber Security Courses Dallas
- Cyber Security Classes Los Angeles
- Cyber Security Certifications Maryland