SAS Macro Language 1: Essentials
Register* for Upcoming Training
September 11 - 12
*Please Note: Completing the registration form will result in the generation of an invoice. Payment is expected within 30 days of course completion. Cancellation less than two weeks prior to class start date will result in a cancellation fee equal to 50% of the registration cost. No Exceptions.
Course Overview
This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with macro code are processed.
This course can help prepare you for the following certification exam(s): SAS Advanced Programming for SAS 9, SAS Certified Clinical Trials Programmer Using SAS 9.
Learn how to
- perform text substitution in SAS code
- automate and customize the production of SAS code
- conditionally or iteratively construct SAS code
- use macro variables and macro functions.
Who should attend
Experienced SAS programmers who have a sound understanding of DATA step processing
and who want to write SAS programs that are reusable and dynamic.
Prerequisites
Before attending this course, you should have completed the SAS Programming 2: Data Manipulation Techniques course or have equivalent knowledge. Specifically, you should be able to
- use a DATA step to read from or write to a SAS data set or external file
- use DATA step programming statements such as IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO
- use SAS data set options such as DROP=, KEEP=, and OBS=
- use character functions such as SUBSTR, SCAN, INDEX, and UPCASE
- form subsets of data using the WHERE clause
- create and use SAS date values and constants
- use SAS procedures such as SORT, PRINT, CONTENTS, MEANS, FREQ, TABULATE, and CHART.
This course addresses Base SAS software.This course is appropriate for students who are using SAS 9 software.
Pricing
SAS Macro Language 1: Essentials: $1,300
Course Outline
Note: This course will last all day for the length of the course. Most classes will start at 9:00AM and end at 5:00PM.
Introduction
- course logistics
- purpose of the macro facility
- program flow
Macro Variables
- introduction to macro variables
- automatic macro variables
- macro variable references
- user-defined macro variables
- delimiting macro variable references
- macro functions
Macro Definitions
- defining and calling a macro
- macro parameters
DATA Step and SQL Interfaces
- creating macro variables in the DATA step
- indirect references to macro variables
- creating macro variables in SQL
Macro Programs
- conditional processing
- parameter validation
- iterative processing
- global and local symbol tables
Learning More
- SAS resources
- beyond this course
Supplemental Materials
- program flow
Course Logistics
Location: FedEx Institute of Technology, 365 Fogelman Drive
Duration: 9:00 AM - 5:00 PM CST
We ask that attendees bring their own device in order to follow along with the class presentations. The temperature in our training room tends to be cooler, we advise you to bring a light jacket or sweater. Parking passes are provided for the garage across to the FedEx Institute of Technology (located on Fogelman Drive).
If you have any additional questions please let us know at fedex@memphis.edu.
Travel Information
Click here to learn more about travel information.