SAS Programming 1: Essentials
Classroom duration: 3.0 days Live Web duration: 6 half-day sessions CEU: 1.8
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 Querying and Reporting Using SAS Enterprise Guide course.
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 attend
Anyone getting started writing SAS programsPrerequisites
Before attending this course, you should have experience using computer software. Specifically, you should be able to- understand file structures and system commands on your operating systems
- access data files on your operating systems
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.
Course Contents
Introduction- course logistics
- an overview of Foundation SAS
- introduction to SAS programs
- submitting a SAS program
- mastering fundamental concepts
- diagnosing and correcting syntax errors
- examining descriptor and data portions
- accessing SAS data libraries
- accessing relational databases (Self-Study)
- introduction to reading data
- using SAS data as input
- subsetting observations and variables
- adding permanent attributes
- using Excel data as input
- doing more with Excel worksheets (Self-Study)
- 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
- creating variables
- creating variables conditionally
- subsetting observations
- introduction to combining data sets
- appending a data set
- contenating data sets
- merging data sets one-to-one
- merging data sets one-to-many
- merging data sets with non-matches
- using global statements
- adding labels and formats
- creating user-defined formats
- subsetting and grouping observations
- directing output to external files
- using the FREQ procedure
- using the MEANS procedure
- using the TABULATE procedure (Self-Study)
- creating bar and pie charts
- creating plots
- enhancing output
Software Addressed
This course addresses the following software product(s): 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.Classroom Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.Live Web Course Materials
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, including the exercise files. Students need to download and print the course materials prior to class.System Requirements
For Live Web, you must- review and follow 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. If
firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and
configured in your environment to participate in the course exercises:
- Base SAS 9.2 or 9.1.3 on a Windows operating system or
SAS Learning Edition.
Important: Students using SAS Learning Edition will need to create a shortcut to the SAS windowing environment (SAS Explorer, Enhanced Editor, Log, and Output windows) for use during the class. Follow these instructions for creating a shortcut to SAS prior to class.
- Base SAS 9.2 or 9.1.3 on a Windows operating system or
SAS Learning Edition.
U.S. Schedule
| 21JUL2008 San Francisco, CA 23JUL2008 Detroit, MI 29JUL2008 Denver, CO 30JUL2008 Dayton, OH 06AUG2008 New York, NY 11AUG2008 Atlanta, GA 13AUG2008 Boston, MA 25AUG2008 Minneapolis, MN 02SEP2008 Live Web, 03SEP2008 Rockville, MD 10SEP2008 Bedminster, NJ 15SEP2008 San Francisco, CA 24SEP2008 Irvine, CA 01OCT2008 Rockville, MD 06OCT2008 Chicago, IL 08OCT2008 Cary, NC 15OCT2008 Washington, DC 20OCT2008 Dallas, TX 22OCT2008 Boston, MA 29OCT2008 Detroit, MI 03NOV2008 Live Web, 05NOV2008 Cary, NC 12NOV2008 Austin, TX 17NOV2008 Charlotte, NC 01DEC2008 Boston, MA 03DEC2008 Overland Park, KS 03DEC2008 San Francisco, CA 10DEC2008 Atlanta, GA 10DEC2008 Philadelphia, PA | 22JUL2008 Des Moines, IA 23JUL2008 Hartford, CT 30JUL2008 Bedminster, NJ 04AUG2008 Live Web, 06AUG2008 Philadelphia, PA 11AUG2008 Cary, NC 13AUG2008 Chicago, IL 26AUG2008 Miami, FL 03SEP2008 New York, NY 08SEP2008 Chicago, IL 10SEP2008 Cary, NC 17SEP2008 Atlanta, GA 24SEP2008 Phoenix, AZ 01OCT2008 San Antonio, TX 06OCT2008 Miami, FL 13OCT2008 Seattle, WA 15OCT2008 Overland Park, KS 20OCT2008 San Francisco, CA 22OCT2008 Minneapolis, MN 29OCT2008 Dayton, OH 03NOV2008 New York, NY 05NOV2008 Chicago, IL 12NOV2008 Hartford, CT 19NOV2008 Irvine, CA 01DEC2008 New York, NY 03DEC2008 Rockville, MD 08DEC2008 Dallas, TX 10DEC2008 Cary, NC 16DEC2008 Indianapolis, IN | 23JUL2008 Austin, TX 28JUL2008 Seattle, WA 30JUL2008 Dallas, TX 05AUG2008 Houston, TX 06AUG2008 Rockville, MD 12AUG2008 Overland Park, KS 20AUG2008 Charlotte, NC 26AUG2008 Richmond, VA 03SEP2008 Philadelphia, PA 10SEP2008 Austin, TX 15SEP2008 Boston, MA 24SEP2008 Hartford, CT 01OCT2008 Philadelphia, PA 03OCT2008 Live Web, 06OCT2008 New York, NY 15OCT2008 Atlanta, GA 15OCT2008 Orlando, FL 21OCT2008 Des Moines, IA 29OCT2008 Bedminster, NJ 29OCT2008 Denver, CO 03NOV2008 Philadelphia, PA 05NOV2008 Rockville, MD 12NOV2008 Sacramento, CA 01DEC2008 Live Web, 02DEC2008 Phoenix, AZ 03DEC2008 Seattle, WA 08DEC2008 Minneapolis, MN 10DEC2008 Chicago, IL 17DEC2008 Bedminster, NJ |
Check for additional and updated schedule information online at support.sas.com/courses/prg1.html.