SAS Programming 1: Essentials

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.

• navigate the SAS Studio programming environment
• navigate the SAS Enterprise Guide programming environment
• navigate the SAS windowing environment
• read various types of data into SAS data sets
• create SAS variables and subset data
• combine SAS data sets
• create and enhance listing and summary reports.

A chi è rivolto

Formati disponibili	Durata
Corso in Aula:	3.0 giorno
Live Web:	5 sessioni di mezze giornate
e-Learning:	14 ore/180 giorno licenza

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

This course addresses Base SAS software.

This course also addresses SAS/ACCESS Interface to PC Files. This course is appropriate for students who are using SAS 9 software.

• The SAS programming process
• Using SAS programming tools
• Understanding SAS syntax

• Understanding SAS data
• Accessing data through libraries
• Importing data into SAS

• Exploring data
• Filtering rows
• Formatting columns
• Sorting data and removing duplicates

• Reading and filtering data
• Computing new columns
• Conditional processing

• Enhancing reports with titles, footnotes, and labels
• Creating frequency reports
• Creating summary statistics reports

• Exporting data
• Exporting reports

• Using Structured Query Language in SAS
• Joining tables using SQL in SAS

• Subsetting data
• merging data sets one-to-one
• merging data sets one-to-many

• using the FREQ procedure for validating data
• using the MEANS procedure for validating data
• using the UNIVARIATE procedure for validating data

• Two case studies