Advance Sas
Advance Sas
Course Duration: 4 Days

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.
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.
- Course Content
- Audience & Prerequisites
- Learning Methdology
Introduction
- Overview of SAS Foundation
- Course logistics
- Course data files
- 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
Introduction
- Overview of SAS Foundation
- Course logistics
- Course data files
- Introducing the Structured Query Language
Basic Queries
- Overview of the SQL procedure
- Specifying columns
- Specifying rows
Displaying Query Results
- Presenting data
- Summarizing data
SQL Joins
- Introduction to SQL joins
- Inner joins
- Outer joins
- Complex SQL joins
Subqueries
- Non-correlated sub-queries
- In-line views
Set Operators
- Introduction to set operators
- The UNION operator
- The OUTER UNION operator
- The EXCEPT operator
- The INTERSECT operator
Creating Tables and Views
- Creating tables with the SQL procedure
- Creating views with the SQL procedure
Advanced PROC SQL Features
- Dictionary tables and views
- Using SQL procedure options
- Interfacing PROC SQL with the macro language
Learning More
- SAS resources
- Beyond this course
Introduction
- Overview of SAS Foundation
- Course logistics
- Creating the course data
Efficient SAS Programming
- Identifying computer resources related to efficiency
Controlling I/O Processing and Memory
- SAS DATA step processing
- Controlling I/O
- Reducing the length of numeric variables
- Compressing SAS data sets
- Using SAS views
Accessing Observations
- Access methods
- Accessing observations by number
- Creating an index
- Using an index
DATA Step Arrays
- Introduction to lookup techniques
- One-dimensional arrays
- Multidimensional arrays
- Loading a multidimensional array from a SAS data set
DATA Step Hash and Hiter Objects
- Introduction
- Hash object methods
- Loading a hash object from a SAS data set
- DATA step hiter object
Combining Data Horizontally
- DATA step merges and SQL procedure joins
- Using an index to combine data
- Combining summary and detail data
- Combining data conditionally
User-Defined Functions and Formats
- User-defined functions
- User-defined formats
Learning More
- Areas of support from SAS
- Other courses to consider
Combining Raw Data Files Vertically
- Combining raw data files vertically
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.
Software Addressed
This course addresses Base SAS software. This course is appropriate for students who are using SAS 9 software.
- Classroom
- Live Web
- Self Paced Learning
Student Testimonials
Ultramax Infonet provides rigorous technical and practical training on SAS . In addition to training it also conducts TNA’s which prepares students for GLOBAL Certification Exams. Training provided for Base and Advance SAS was fantastic for most of the modules.

Rishab Bothra

Swati Jadhav

Neetu Sharma
It has been a great experience at Ultramax infonet for me, right from class room to placement.
I am immensely thankful to Ultramax infonet pune for providing SAS training program which helped me groom and prepare myself for the challenges in the industries. The Faculty and staff are all dedicated to student success and innovation. The flexible and professional environment for learning provides the opportunity to explore yourself

Palash Sahare

Shripad Binawade
Google referred me to approach “Ultramax” and I was glad to connect with them on proper instruction my training for three modules Base, Advance SAS and Predictive Modeling were successfully completed on time. The staff is very kind and informative. Proper time for practicing was provided which helped in clearing our doubts. My experience can be rated as 4.8/5. Proper guidance. Good practice labs and sessions for doubt solving. Ultramax, did help we get a nice job

Tanvi Yedke
I wanted to learn Base, Advance SAS and Predictive Modeling. It was the best institute to learn and get trained from here. They provide with all best facilities, classrooms are very well maintained and equipped. Trainer for base and advance was very good. Concepts were very clear and trainers were also professional.Overall experience was very well. It provided by quite good opportunities for placement

Kalyani Uttarwar

Harsha Kamat
