Advanced SAS Programming
Learn advanced high-demand skills in SAS programming Get exam-ready for SAS’s Advanced Programmer certification

4 Weeks programme

Contact hours: 20 hours

  • Conceptual Learning
  • Hands-on Learning
  • Projects/ Assignments
For Enrollment
Programme Objectives
SAS, the leading analytical software, has its products suits that cater to various applications from business intelligence to business analytics, from descriptive analytics to prescriptive analytics. While “Base SAS Programming” programme introduces SAS environment to new learners primarily in terms of data management, “Advanced SAS Programming” programme aims to equip participants with advanced skills in the SAS-platform based analytics environment. Building up from Base SAS Programming concepts, the programme introduces participants to advanced data management in the SAS environment, in particular, carrying out analyses using SAS SQL procedure (Structured Query Language) with the data available in different databases or data mart and programming in SAS Macro Language to enhance efficiency and effectiveness. 

This programme offers a structured way of learning that will enable the participants to prepare for the “SAS Certified Advanced Programmer for SAS 9 Credential” certification under the SAS Global Certification programme.
Who should go for the Programme?
Individuals who are quite familiar with SAS programming basics or want to extend their SAS programming skills beyond the “Base SAS Programming” programme, this course , “Advanced SAS Programming” programme, is the ideal course to upskill themselves in the world of analytics, in particular, SAS based analytics environment. This course is also designed & developed in a manner that individuals, who want to appear for the “SAS Certified Advanced Programmer for SAS 9 Credential” certification, can treat it as a structured preparatory course for the same.
The programme offers substantial benefit to all participants, with aspiring to carve out a career for themselves in the high-demand & rapidly-growing Analytics industry where SAS is an extremely well-entrenched tool. 

Key Takeaways

  • Gain knowledge of & expertize in various advanced programming concepts in the SAS environment
  • Apply the capabilities of the SAS SQL Procedure and its role in data management
  • Mastering in working with the SAS Macro Language for complex tasks and automating programs
  • Acquire expertize in advanced efficiency-enhancing techniques of data management
  • Appreciate the utility of indexes in various data management and data transformation tasks Post successful completion of the programme, participants will be confident to appear for the SAS Global Certification programme, in particular, the “SAS Certified Advanced Programmer for SAS 9 Credential”.

Learning Mode

Curriculum Overview

The SQL Procedure
Running queries with a single table
Running queries by joining tables
Generating detailed/ summary query reports
Constructing sub-queries in SAS
Merging/ Splitting datasets using the SQL Procedure
Sorting datasets using the SQL Procedure
Data manipulations using the SQL Procedure
Comparison of the SQL Procedure with the Data Statement
The SAS Macro Language – key concepts
SAS Macro Language variables
Creating SAS macros
Automating programs by calling SAS macros
Understanding the usage of SAS macro functions
The SAS Macro Language – various system options
Creating data-driven programs using SAS macros
Creating an Index
Efficient merging through indexing
Eliminate duplicate data using the Data Statement
Eliminate duplicate data using the SORT Procedure
Eliminate duplicate data using the SQL Procedure

Are there any Learning Pre-requisites?

The “Advanced SAS Programming” programme is essentially of a relatively advanced nature, and hence there are certain learning pre-requisites for the programme. In order to enhance the efficiency & effectiveness of participants’ learning, it is desirable that participants possess adequate exposure to Base SAS programming or fundamental SAS programming.
Participants are advised to note that the SAS Global Certification programme mandates aspirants to clear the “SAS Certified Base Programmer for SAS 9 Credential” prior to appearing for the “SAS Certified Advanced Programmer for SAS 9 Credential”.
Accordingly, it is advisable that participants either be a “SAS Certified Base Programmer for SAS 9 Credential” under the SAS Global Certification programme, or have successfully completed the “Base SAS Programming” programme from insAnalytics (or an equivalent training programme).


Advanced SAS Programming

MEET Our Consultants & Faculty

Mr. Goutam Das

Ph.D. in Foreign Direct Investment (submitted), IIFT Delhi.
M.Tech. (Computer Engg), IIT Kharagpur.
Alumnus of IIM Calcutta and ISI Delhi.
Ex-Global Analytics Head of TCS.
25+ years of experience across industry verticals.

Read More

Dr Nidhan "Neal" Choudhuri

Ph.D. (Statistics), Michigan State University.
B. Stats. & M. Stats., Indian Statistical Institute, Calcutta.
Ex-Chief Scientist & Founder, PlanetRisk Inc, Bethesda, US.
20+ years of industry exp. with Morgan Stanley, Barclays Capital etc.

Read More

Dr. Saswati Bhattacharyya

Ph.D. and M. Stat. from ISI Calcutta.
22 + years of exp. in IT, Statistical Analysis and Data Science.
Specialized in Image Processing, Logistic optimization of Vehicle using GPS data tracking.
Expertise in Optimal Media (TV Ad) assignment.

Read More

Mr. Aditya Biswas

B. Tech. (Mechanical) & M. Tech (Industrial Engg. & OR) IIT, Kharagpur.
Ex-Principal Consultant in TCS, Head of IT in Allahabad Bank.
Specialized in Process Optimization, R & D and Management Consulting.
30+ yrs of industry exp.

Read More

Amrita Saha

M.Sc. Economics, Calcutta Univ.
8+ yrs of research and industrial exp. in Business Analysis, Business Forecasting, Statistical & adv. Econometrics.
Extensive hands-on exp. in Python, R, Rattle, WEKA, Tableau, QlikView, Power BI etc.

Read More

Somnath Sinha

B.Tech. (Electrical Engg), IIT Bombay.
PGDM, IIM Calcutta.
20+ yrs with IBM as IT Services Leader, CIO, HR Director &s Director, Integrated Operations.
Partnered with Accenture, IBM, PwC, KPMG, E&Y, etc.
30+ years of industry exp.

Read More

Prof. B. B. Chakrabarti

Ph.D. in Economics, Gold Medalist PGDM, IIM Calcutta.
Gold Medalist - BE, Jadavpur Univ.
20+ yrs as a Renowned Prof of Finance at IIM Calcutta.
24+ years of Industry experience with United Nations, Deustche Bank etc.

Read More

Dr. Sunanda Roy

Ph.D. (Materials Science & Engg), Singapore- MIT.
M. Tech. Materials Science & Engg, IIT Kharagpur.
International Research Reviewer of Royal Society of London, Elsevier Amsterdam.
12+ yrs of exp. in Research & Academics.

Read More
© 2017 All rights reserved
+ +