search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

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 programs

Approximate duration:  24 hours

License period:  365 days

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.

Introduction

• course logistics
• an overview of Foundation SAS

Getting Started with SAS

• introduction to SAS programs
• submitting a SAS program

Working with SAS Syntax

• mastering fundamental concepts
• diagnosing and correcting syntax errors

Getting Familiar with SAS Data Sets

• examining descriptor and data portions
• accessing SAS data libraries
• accessing relational databases (Self-Study)

Reading SAS Data Sets

• introduction to reading data
• using SAS data as input
• subsetting observations and variables
• adding permanent attributes

Reading Excel Worksheets

• using Excel data as input
• doing more with Excel worksheets (Self-Study)

Reading Delimited Raw Data Files

• using standard delimited data as input
• using nonstandard delimited data as input

Validating and Cleaning Data

• 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

Manipulating Data

• creating variables
• creating variables conditionally
• subsetting observations

Combining SAS Data Sets

• 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

Enhancing Reports

• using global statements
• adding labels and formats
• creating user-defined formats
• subsetting and grouping observations
• directing output to external files

Producing Summary Reports

• using the FREQ procedure
• using the MEANS procedure
• using the TABULATE procedure (Self-Study)

Introduction to Graphics Using SAS/GRAPH (Self-Study)

• creating bar and pie charts
• creating plots
• enhancing output

Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year. 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.

You should

• use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
• 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.

.

Share Your Thoughts
If you have suggestions for this course, let us know by adding to our Interest List.



This page was created using SAS software.