Do I need to do anything in advance of the course?

You will be provided pre-course reading to familiarize yourself with the material before the class begins.

Is it feasible to pay for the programme in instalments?

Yes. Learn more about the payment options available at Croma Campus by visiting our payment plans website.

What happens if I have to cancel or won't be able to make it to the class?

Because we only offer two to three training sessions per year, you will be eligible to enroll for the next one.

What are the various methods of payment?

Yes, a range of payment methods is available.

Home /Data Analytics & BI/ SAS Adv Training Program

Become proficient in working in a SAS environment. Enroll now and learn from a SAS expert.

4.9 out of 5 based on 26599 votes

4.2/5

4.8/5

4.6/5

4.3/5

4.5/5

Course Duration

20 Hrs.

Live Project

2 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

GUIDE ME

Speciality

200+

Professionals Trained

Batches every month

20+

Countries & Counting

100+

Corporate Served

CURRICULUM REAL STORIES PROJECTS COURSE FEE SELF-ASSESSMENT ACTIVITIES PLACEMENTS practice tests ENROLL NOW

CURRICULUM & PROJECTS

SAS Adv Training Program

This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. Further, the course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.

You will Perform text substitution in SAS code, learn to use macro variables and macro functions, automate and customize the production of SAS code, conditionally or iteratively construct SAS code, write self-modifying, data-driven programs. Moving ahead, you will also learn how to process SAS data using Structured Query Language (SQL).

In this program you will learn:

SAS Programming Advanced Techniques

SAS Macro Language Essentials

SAS SQL Essentials

Get full course syllabus in your inbox

Getting Started

Setting up for this course.

DATA step review.

Using Advanced Functions

Using a variety of advanced functions.

Performing pattern matching with Perl regular expressions.

Defining and Processing Arrays

Defining and referencing one-dimensional arrays.

Doing more with one-dimensional arrays.

Defining and referencing two-dimensional arrays.

Defining and Processing Hash Objects

Declaring hash objects.

Defining hash objects.

Finding key values in a hash object.

Writing a hash object to a table.

Using hash iterator objects.

Using Utility Procedures

Creating picture formats with the FORMAT procedure.

Creating functions with the FCMP procedure.

Get full course syllabus in your inbox

Introduction

Why SAS macro

Setting up for this course.

SAS Macro Facility

Program flow.

Creating and using macro variables.

Storing and Processing Text

Macro functions.

Using SQL to create macro variables.

Using the DATA step to create macro variables.

Indirect references to macro variables.

Working with Macro Programs

Defining and calling a macro.

Macro variable scope.

Conditional processing.

Iterative processing.

Developing Macro Applications

Storing macros.

Generating data-dependent code.

Validating parameters and documenting macros.

Get full course syllabus in your inbox

Essentials

Setting up for this course.

Overview of SAS Foundation.

Course logistics.

Course data files.

Introducing the Structured Query Language.

Overview of the SQL procedure.

Exploring tables.

Specifying columns.

PROC SQL Fundamentals

Sub-setting data.

Presenting data.

Summarizing data.

Creating and managing tables.

Using DICTIONARY tables.

SQL Joins

Introduction to SQL joins.

Inner joins.

Outer joins.

Complex SQL joins.

Subqueries

Noncorrelated subqueries.

Correlated subqueries.

In-line views.

Creating views with the SQL procedure.

Subqueries in the SELECT clause.

Remerging summary statistics.

Set Operators

Introduction to set operators.

The INTERSECT operator.

The EXCEPT operator.

The UNION operator.

The OUTER UNION operator.

Using and Creating Macro Variables in SQL

Interfacing PROC SQL with the macro language.

Creating data-driven macro variables with a query.

Using macro variables in SQL.

Accessing DBMS Data with SAS/ACCESS

Overview of SAS/ACCESS technology.

SQL pass-through facility.

SAS/ACCESS LIBNAME statement.

PROC Fed SQL.

Get full course syllabus in your inbox

Placement Guide

What is an Interview

Tips to clear an Interview

Common Interview questions and answers

SAS Advanced Interview Questions and Answers

Resume Building Guide

Career roadmap and certifications

Attempt for related Global Certification Exam

Start applying for Jobs

Get full course syllabus in your inbox

Generate Detail Reports by Working with a Single Table, Joining Tables, Or Using Set Operators in SQL

Use PROC SQL to perform SQL queries.

Select columns in a table with a SELECT statement and FROM clause.

Create a table from a query result set.

Create new calculated columns.

Assign an alias with the AS keyword.

Use case logic to select values for a column.

Retrieve rows that satisfy a condition with a WHERE clause.

Subset data by calculated columns with the CALCULATED keyword.

Join tables - inner joins, full joins (coalesce function), right joins, left joins, cross

joins.

Combine tables using set operators - union, outer join, except, intersect.

Sort data with an ORDER BY clause.

Assign labels and formats to columns.

Generate Summary Reports by Working with a Single Table, Joining Tables, Or Using Set Operators in The Sql.

Summarize data across and down columns using summary functions (AVG,

COUNT, MAX, MIN, SUM).

Group data using GROUP BY clause.

Filter grouped data using HAVING clause.

Eliminate duplicate values with the DISTINCT keyword

Construct Sub-Queries and In-Line Views Within an SQL Procedure Step

Subset data by using non-correlated subqueries.

Reference an in-line view with other views or tables (multiple tables).

Use Special Features of the SQL Procedure.

Use SAS data set options with PROC SQL (KEEP=, DROP=, RENAME=,

OBS=).

Use PROC SQL invocation options (INOBS=, OUTOBS=. NOPRINT,

NUMBER)

Use PROC SQL with the SAS Macro Facility to create macro variables with the

INTO keyword.

Use SAS functions (SCAN, SUBSTR, LENGTH).

Access SAS system information by using DICTIONARY tables (members,

tables, columns)

Create and Manipulate SAS Date Values

Explain how SAS stores date and time values.

Use SAS informants to read common date and time expressions.

Use SAS date and time formats to specify how the values are displayed

Get full course syllabus in your inbox

Create And Use User-Defined and Automatic Macro Variables Within the SAS Macro Language

Define and use macro variables.

Use macro variable name delimiter. (.)

Use INTO clause of the SELECT statement in SQL.

Use the SYMPUTX routine in a DATA Step.

Control variable scope with:

%GLOBAL statement

%LOCAL statement

SYMPUTX scope parameter

Get full course syllabus in your inbox

Process Data Using 1 and 2 Dimensional Arrays.

Define and use character arrays.

Define and use numeric arrays.

Create variables with arrays.

Reference arrays within a DO loop.

Specify the array dimension with the DIM function.

Define arrays as temporary arrays.

Load initial values for an array from a SAS data set.

Process Data Using Hash Objects

Declare hash and hash iterator objects

Dataset argument

Ordered argument

Multidata argument

Get full course syllabus in your inbox

+ More Lessons

Course Design By

Nasscom & Wipro

Course Offered By

Croma Campus

Real

Stories

success

inspiration

Abhishek

career upgrad

Upasana Singh

career upgrad

Shashank

career upgrad

Abhishek Rawat

career upgrad

Course Duration

20 Hrs.

Know More...

Weekday1 Hr/Day

Weekend2 Hr/Day

Training ModeClassroom/Online

Flexible Batches For You

28-Jun-2025*
Weekend
SAT - SUN
Mor | Aft | Eve - Slot

30-Jun-2025*
Weekday
MON - FRI
Mor | Aft | Eve - Slot

25-Jun-2025*
Weekday
MON - FRI
Mor | Aft | Eve - Slot

28-Jun-2025*
Weekend

SAT - SUN

Mor | Aft | Eve - Slot

30-Jun-2025*
Weekday

MON - FRI

Mor | Aft | Eve - Slot

25-Jun-2025*
Weekday

MON - FRI

Mor | Aft | Eve - Slot

Course Price :

For Indian

17,000 15,300 10 % OFF, Save 1700

Expires in: 00D:00H:00M:00S

Program fees are indicative only* Know more

SELF ASSESSMENT

Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals

Get exclusive
access to career resources
upon completion

Mock Session

You will get certificate after
completion of program

LMS Learning

You will get certificate after
completion of program

Career Support

You will get certificate after
completion of program

Showcase your Course Completion Certificate to Recruiters

Training Certificate is Govern By 12 Global Associations.
Training Certificate is Powered by “Wipro DICE ID”
Training Certificate is Powered by "Verifiable Skill Credentials"

in Collaboration with

Not Just Studying

Name: SAS Adv Training Program
Item: SAS Adv Training Program
Rating: 4.90

We’re Doing Much More!

Empowering Learning Through Real Experiences and Innovation

Career Transition

Career Gap

Placement Activities

Placement Drives

Latest Hiring

Whats App Reviews

Mock Interviews

Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.

How Croma Campus Mock Interview Works?