SAS Programming 1: Essentials (PRG1)
Course duration: 2.5 days
This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.
This course can help prepare you for the following certification exam(s): SAS Base Programming Exam for SAS 9.
Learn how to
- navigate the SAS windowing environment
- read various types of data into SAS data sets
- validate and clean SAS data sets
- create SAS variables and subset data
- combine SAS data sets
- create and enhance listing and summary reports.
Who should attendAnyone getting started writing SAS programs
Before attending this course, you should have experience using computer software. Specifically, you should be able to
No prior SAS experience is needed. If you do not feel comfortable with the prerequisites or are new to programming and think that the pace of this course might be too demanding, you can take the SAS Programming Introduction: Basic Concepts course before attending this course. SAS Programming Introduction: Basic Concepts is designed to introduce you to computer programming and presents a portion of the SAS Programming 1: Essentials material at a slower pace.
- understand file structures and system commands on your operating systems
- access data files on your operating systems.
Getting Started with SAS
- course logistics
- overview of Foundation SAS
Working with SAS Syntax
- introduction to SAS programs
- submitting a SAS program
Getting Familiar with SAS Data Sets
- mastering fundamental concepts
- diagnosing and correcting syntax errors
Reading SAS Data Sets
- examining descriptor and data portions
- accessing SAS data libraries
- accessing relational databases (self-study)
Reading Excel Worksheets
- introduction to reading data
- using SAS data as input
- subsetting observations and variables
- adding permanent attributes
Reading Delimited Raw Data Files
- using Excel data as input
- doing more with Excel worksheets (self-study)
Validating and Cleaning Data
- using standard delimited data as input
- using nonstandard delimited data as input
- introduction to validating and cleaning data
- examining data errors when reading raw data files
- validating data with the PRINT and FREQ procedures
- validating data with the MEANS and UNIVARIATE procedures
- cleaning invalid data
Combining SAS Data Sets
- creating variables
- creating variables conditionally
- subsetting observations
- introduction to combining data sets
- appending a data set (self-study)
- concatenating data sets
- merging data sets one-to-one
- merging data sets one-to-many
- merging data sets with nonmatches
Producing Summary Reports
- using global statements
- adding labels and formats
- creating user-defined formats
- subsetting and grouping observations
- directing output to external files
Introduction to Graphics Using SAS/GRAPH (Self-Study)
- using the FREQ procedure
- using the MEANS procedure
- using the TABULATE procedure (self-study)
- creating bar and pie charts
- creating plots
- enhancing output
- SAS resources
- beyond this course
Classroom: Students attend classroom courses in one of our public training centers. You receive
a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with
their instructor and fellow classmates in real time. Each student receives an e-mail
with instructions on how to join the class three business days before the class begins.
The instructions e-mail includes a link to download the course materials.
Students need to download and print the course materials prior to class.
e-Course: Students have unlimited 24/7 access to the product for the specified license period.
The course requires only a standard Web browser and a free Flash plug-in. The course includes data
that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions,
step-by-step demonstrations, and a Certificate of Completion.
This course addresses Base SAS. This course also addresses SAS/ACCESS to PC Files and SAS/GRAPH software. This course is appropriate for students who are using SAS 9 software.
For Live Web,
- review and meet the general system requirements.
- complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
- run this test to connect to a virtual lab session.
- have the latest version of Macromedia Flash Player installed
- have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.