All Courses:

| List Complete | List by Job Role

SAS Programming 1: Essentials (PRG1)




Course duration: 2.5 days

Overview

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 attend

Anyone getting started writing SAS programs

Prerequisites

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 Outline


Introduction

  • course logistics
  • 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 (self-study)
  • concatenating data sets
  • merging data sets one-to-one
  • merging data sets one-to-many
  • merging data sets with nonmatches
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
Learning More
  • SAS resources
  • beyond this course

Course Materials

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.

System Requirements

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.
For e-Courses,
  • 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.

Location Start Day Duration Fee
Dubai 2.5 days 1250.0 US

 

 
www.sas.com | support.sas.com
Terms of Use & Legal Information | Privacy Statement