Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

SAS(R) Macro Language 1: Essentials for FedEx Institute

  • Tuition USD $1,450 GSA  $1,178.84
  • Reviews star_rate star_rate star_rate star_rate star_half 2019 Ratings
  • Course Code FEMC1
  • Duration 2 days
  • Available Formats Classroom

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.

Skills Gained

  • 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 Can Benefit

  • 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.

Course Details

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

I am impressed with the level of attention and swift support from ExitCertified. Great work

ExcitCertified(Tech Data) was great and I enjoyed my experience with them. Looking forward to taking more courses with them!

The course is perfectly designed with material and labs to get hands on experience on AWS, nicely done!

Its good. ExitCertified brings great resources to excel your learning journey.

it had already been recommended to me before but due to lack of time and I didn't dare decision, I definitely regret taking classes earlier with TechData.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward