- Home
- SAS Macro Language 1: Essentials
SAS Macro Language 1: Essentials
his course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems.
Power up your staff’s skills and boost your business
Course Description
About Program
Format of Training
Prerequisite
Training Features
Course Curriculum
Project
Certificate
FAQs
Course Fees
Watch
ContactCourse Description
Experienced SAS programmers who have a sound understanding of DATA step processing and who want to write SAS programs that are reusable and dynamic
About Program
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.
Format of Training
Live Web Classroom
Training is Led by an expert instructor live online using live web training platform, and this are not pre recorded lectures. Trainer can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries.
Taste of Live Web - is a perfect platform for indivudals who fear online training. SAS® gives an opportunity to all the registrants to have a closer look at different courses given below with a blend of Online Learning.
All the benefits of the classroom without the travel:
Classroom training options include courses offered in our regional training centers or via our Live Web classroom.
Taught by certified instructors at High-Tech facilities across the country:
- A SAS expert at your side.
- Focused learning away from the office
- Networking opportunities
- State-of-the-art facilities
- Electronic course notes downloadable to your device and permission to print
- Business Knowledge Series: in-depth courses on the latest business topics
- We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.
Self Paced Learning Platform
SAS e-learning courses are online, hands-on tutorials that you can access whenever and wherever is convenient for you – satisfaction guaranteed. All you need is an internet connection. With e-learning from SAS, you can:
- Train when and where you want.
- Learn at your own pace.
- Access the same content as our instructor-based courses, only optimized for self-study.
- Earn a certificate of completion.
- Benefit from courses created by SAS experts.
Free Training e-learning subscription - please connect with us
Get a quick, easy start with SAS® online training – or expand your learning without spending a dime.
Prerequisite
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.
Training Features
- 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.
Course Curriculum
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
Project
- creating macro variables in the DATA step
- indirect references to macro variables
- creating macro variables in SQL
- conditional processing
- parameter validation
- iterative processing
- global and local symbol tables
Certificate
FAQs
Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.
Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.
Course Fees
Are you ready to take on SAS Macro Language 1: Essentials?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
Batch Schedule SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.