This course provides you with thorough understanding of the Base SAS programming language. You get the opportunity to work with basic access to data, manipulation of data as well as presentation of data from SAS Enterprise Guide, SAS Studio or Display Manager System.
You will learn how to master the most important techniques within data step programming, load data, manage data and organize data efficiently in SAS data sets. This course combines the course content of the two courses SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques.

• Program in SAS
• Work with SAS Enterprise Guide, SAS Studio or Display Manager System
• Use various data formats
• Create SAS variables and select subset of data
• Combine SAS data
• Create reports
• Validate SAS data
• Control input and output of SAS data
• Work with DO loops and arrays < li> Use alphanumeric, numeric and date functions

Who should attend

Formats available	Standard duration
Classroom:	4 days

None

This course addresses SAS/ACCESS, Base SAS, SAS Enterprise Guide, SAS/GRAPH software.

This course can be run from both SAS Display Manager and in SAS Enterprise Guide or SAS Studio. On the course, the following software modules are used: SAS/ACCESS® Interface, Base SAS, SAS Enterprise Guide and SAS/GRAPH software

• Overview of SAS Foundation
• Course overview
• Overview of data

• Introduction to SAS programs
• Run SAS programs
• Syntax for SAS programs

• Create temporary SAS files
• Create libraries
• Save files in permanent libraries

• Creation of list report
• Sorting and grouping of data
• Additional options in the list report

• Use SAS formats
• Create user-defined formats

• Access to SAS data
• Manipulate SAS data

• Access to Excel spreadsheets
• Access to databases

• Load unformatted data
• Load formatted data
• Manage missing values
• Load data in fixed columns
• Control data loading

• Conditional management with if-then-else
• Functions for alphanumeric values
• Functions for numeric values
• Date functions
• Conversion of data types

• Combine SAS data in various ways

• Proc FREQ
• Proc MEANS and Proc UNIVARIATE
• Proc TABULATE
• Output Delivery System

• Explicit output
• Output for several SAS data sets
• Select variables and observations

• Create a variable for accumulation of values

• Use of the PUTLOG statement
• Use of Debugger in SAS Enterprise Guide

• Management of DO loops
• Conditional management of DO loops
• Work with SAS Arrays

• Rotate data with the data step
• Rotate data with PROC TRANSPOSE

• Use of the SQL procedure
• Introduction to SAS macro language

• Additional SAS resources
• Overview