Advanced SAS: Macros & SQL

₹6,600 + taxes

Enroll Now

₹6,600 + taxes

New to Analytics?
Sign Up for a free course!

Study advanced techniques in SAS - the most popular analytics language. Data Scientists, grab the opportunity to learn advanced data manipulation using SQL and Macros. Leap ahead in SAS by mastering the use of SQL as a data manipulation tool, the components of the SAS macro facility, the designing and debugging of macro systems, and more. Download Course Details
Learning Mode:  Online
Certification Certification:  Jigsaw Academy
Course Duration:  1 month
Access Duration:  3 months

What you get

Faculty & Technical Support
Mobile App Access
Case Studies
UChicago Certification
Guaranteed Internships
IBM Certification
IBM Certification
In-Person Faculty Support
Placement Support
Capstone Project
Online Classes
Online Q&A Sessions
IOT Hardware Kit
IOT Hardware Kit
IconNot Applicable
* T&C apply

Tools & Curriculum Covered

Pre-Requisites: Intermediate knowledge of base SAS programming is essential

Uses of Proc SQL

Creating a table using PROC SQL

How to obtain data from multiple tables

Understanding sub-queries and indexes

Treatment of data

Data transformations using PROC SQL

Special data processing using PROC SQL

PROC SQL pass through facility

Unique PROC SQL functions

Macros and Arrays

Case Study - Macro non-graded: importing and manipulating the region_sales data using SAS Macros

Case Study - Array non-graded: Manipulating a credit card data using SAS Arrays

Case Study - Macro graded: Using SAS Macros to import and manipulate CSV and text files

Case Study - Array graded: Data manipulation and exploration of text and csv files using SAS Arrays



Download Course Details


You can start by browsing through our Explore Analytics section. You could also visit our Analytics Training blog for more reading material, reports and in-depth articles on other topics like data science, machine learning, artificial intelligence, Big Data and IOT. If you’d prefer watching videos, head over to our Youtube channel.

Participants can pay through an online transfer, debit card or credit card (Visa, Master Card and Amex). Foreign students can pay via credit card or PayPal.

Our programs have been designed for all students regardless of any prior knowledge of analytics, statistics or coding. We have had and continue to have many successful students who are from non-IT or non-mathematics backgrounds. But the subject matter is quantitative, and hence a background in maths, statistics or coding is helpful. If you have specific questions regarding eligibility or prerequisites for any program, please contact us at +91 9019217000.

Jigsaw Academy has been at the forefront of analytics in India for the last 8 years. In that time, the institute has been ranked #1 in the country by Analytics India Magazine multiple times, including for the last two years running. With our expert faculty and carefully designed courses, we have been able to help several students build towards a career in analytics. We also have ongoing collaborations with prestigious institutes such as the University of Chicago and Bocconi University in Milan. In addition to individuals, we are also invested in providing high-quality analytics training at the corporate level.