This course is designed for programmers who need a solid foundation for programming in SAS in a condensed timeframe and who can learn at an accelerated pace. The course teaches you SAS programming essentials, such as creating SAS data sets and writing summary reports, as well as data manipulation techniques. It teaches you to use the macro facility to reduce development and maintenance time for your programs. It also teaches you to use SAS SQL processing techniques to write basic queries and subqueries and to output query results. Although this course pulls from SAS Programming 1: Essentials, SAS Programming 2: Data Manipulation Techniques , SAS Macro Language 1: Essentials, and SAS SQL 1: Essentials, it does not cover all topics from these four courses.

Learn how to

• create SAS data sets from raw data files, SAS data sets, and Excel spreadsheets
• validate data
• write and enhance reports
• create variables
• manipulate data values
• subset data
• combine SAS data sets
• use macro variables and programs
• use SAS SQL processing techniques to write basic queries and subqueries and to output results.

Who should attend

SAS users who need a solid foundation for programming in SAS in a condensed timeframe and who can learn at an accelerated pace

Formats available	Standard duration
Classroom:	5.0 days
Live Web Classroom:	10 half-day session(s)

Before attending this course, you should either have programming experience or familiarity with another programming language.

This course addresses Base SAS software.

Getting Started with Programming

• submitting a SAS program
• mastering fundamental concepts
• diagnosing and correcting syntax errors

Getting Familiar with SAS Data Sets

• examining descriptor and data portions
• accessing SAS data libraries

Reading SAS Data Sets, Excel Worksheets, and Raw Data Files

• using SAS as input
• subsetting observations and variables
• adding permanent attributes
• using Excel data as input
• using standard and nonstandard delimited data as input

Data Quality

• 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

Summary Reports

• using the FREQ procedure
• using the MEANS procedure

Enhancing Reports

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

DATA Step

• creating variables
• creating variables conditionally
• subsetting observations

Controlling I/O

• outputting multiple observations
• writing multiple SAS data sets

Summarizing in the DATA Step

• creating an accumulating total variable
• accumulating totals for a group of data

Data Transformation

• manipulating character values
• manipulating numeric values
• converting variable type

Iterative Processing

• DO loop processing
• SAS array processing
• using SAS arrays

Combining Data Rows

• combining rows vertically
• combining rows horizontally

Macro Variables and Macro Programs

• macro variable references
• user-defined macro variables
• delimiting macro variable references
• macro functions
• defining and calling a macro
• macro parameters
• conditional processing

Basic Queries and Outputting Query Results

• overview of the SQL procedure
• specifying columns
• specifying rows
• presenting data
• creating tables

Subqueries and Joins

• noncorrelated subqueries
• inner joins