Certified SAS Professional

Power packed course for those interested in clearing Global SAS certification exam...and more

This is a power-packed program for SAS certification aspirants and most sure shot way to prepare Base SAS Global Certification. Evolved from our most popular SAS course, called SAS Edge, this online SAS training is specifically designed and curated to help candidates thoroughly prepare for Global SAS certification program. Also, important concepts from advanced SAS (Proc SQL and SAS Macros) are included, making it best job-oriented SAS training program too.


Apart from the online SAS training, you would get Expert guidance for your one-to-one doubt clearing and also get detailed SAS course certification preparation material especially curated by our experts. Also, you may avail our special offer where you get  1 Official Base SAS Mock Exam ($62) + Base SAS Global Certification Exam (one attempt worth $180) all for only INR 11,000 in addition to the course fee


Course duration: 60 hours (Atleast 36 hours live training + Practice and Self-study)

Who Should do this course?

Candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Business Management who want to develop hands-on SAS skills and clear the Base SAS certification exam.

Enroll to this course

Combo Deals!

Learn more, save more.
See our combo offers here.

Course Duration 60 hours
Classes 12
Tools SAS
Learning Mode Live/Video Based
Next Batch11th February, 2017

Introduction to the Analytics world and SAS role

Analytics World

  • Introduction to Analytics
  • ETL CONCEPT and role of SAS in ETL
  • SAS in advanced analytics
  • SAS Certification: Induction and walk through

Getting Started with SAS

  • SAS software installation
  • Introduction to SAS, GUI
  • Different components of SAS language
  • All SAS programming windows
  • Concept of SAS Libraries and Creating Libraries
  • Variable Attributes - (Name, Type, Length, Format, In format, Label)
  • Importing Data and Entering data manually

Understanding Datasets

  • Descriptor Portion of a Dataset (Proc Contents)
  • Data Portion of a SAS Dataset
  • Variable Names and Values
  • SAS Data Libraries

Accessing the Data

Understanding Data Step processing

  • Data Step and Proc Step
  • Data step execution
  • Compilation and execution phase
  • Input buffer and concept of PDV

Importing Raw Data files

  • Column Input and List Input and Formatted methods
  • Delimiters, Reading missing and non standard values
  • Reading one to many and many to one records
  • Reading Hierarchical files
  • Creating raw data files and put statement
  • Formats / Informat

Importing and Exporting Data (Fixed Format / Delimited)

  • Import Wizard
  • Proc Import / Delimited text files
  • Proc Export / Exporting Data from SAS
  • Datalines / Cards
  • Atypical importing cases (mixing different style of inputs)
    • Reading Multiple Records per Observation
    • Reading “Mixed Record Types”
    • Sub-setting from a Raw Data File
    • Multiple Observations per Record
    • Reading Hierarchical Files
  • Importing Tips

Data Understanding, Managing and Manipulation

Understanding and Exporing Data

  • Introduction to basic Procedures - Proc Contents, Proc Print
  • Operators and Operands
  • Conditional Statements (Where, If, If then Else, If then Do and select when)
  • Difference between WHERE and IF statements and limitation of WHERE statements
  • SAS Labels, Commenting
  • SAS System Options (OBS, FSTOBS, NOOBS etc…)

Data Manipulation

  • Proc Sort - with options / De-Duping
  • Accumulator variable and By-Group processing
  • Explicit Output Statements
  • Nesting Do loops
  • Do While and Do Until Statement
  • Array elements and Range

Combining Datasets (Appending and Merging)

  • Concatenation
  • Interleaving
  • Proc Append
  • One To One Merging
  • Match Merging
  • IN = Controlling SAS merge and Indicator

Functions

  • General form of SAS Functions
  • Arithmetic Functions
  • Date and Time Functions
  • Text Manipulation Functions
  • Nested Functions

Data Analysis and Reporting

  • Proc Freq
  • Proc Format for user defined formats
  • Proc Means
  • Proc Summary
  • Proc tabulate
  • Proc report
  • Concept of the Output Delivery System
  • Using ODS Statements to save data on external destination

Advance SAS - Data Mining with Proc SQL

  • Introduction to Proc SQL
  • Basics of General SQL language
  • Creating table and Inserting Values
  • Retrieve & Summarize data
  • Group, Sort & Filter
  • Using Joins (Full, Inner, Left, Right and Outer)
  • Reporting and summary analysis
  • Concept of Indexes and creating Indexes (simple and composite)
  • Connecting SAS to external Databases
  • Implicit and Explicit pass through methods

Advanced SAS - SAS Macros

  • Global and Local Variables
  • Macro Parameters and Variables
  • Different types of Macro Creation
  • Defining and calling a macro
  • Using call Symput and Symget
  • Macros options (mprint symbolgen mlogic merror serror)

Working smartly with SAS

Debugging SAS

  • How to read log file efficiently
  • Tips to debug code

Efficient SAS Programming

  • Code optimization and Efficient SAS Programming Techniques
  • Saving CPU Time, I/ O processing time
  • Disk Space Saving Measures
  • Memory saving tips

List of Procedures covered

  • Proc Contents
  • Proc Append
  • Proc Sort
  • Proc Datasets
  • Proc Print
  • Proc Format
  • Proc Transpose
  • Proc Import
  • Proc Export
  • Proc Print
  • Proc Tabulate
  • Proc Report
  • Proc Means
  • Proc Summary
  • Proc Freq

2 free SAS certification mock tests

SAS certification question bank

Additional time for doubt clearing with the faculty

Discount vouchers, upto $25, subjected to availability

Also, you may avail all below for additional cost of just INR 11,000:

1 Official Base SAS Mock exam (worth $62)

1 attempt at Base SAS Certification exam (worth $180)

For how long are the recordings available to me?

6 months post your course completion. Virtually the recordings are available to you for lifetime, but for judicious use of IT resources, the access to these recordings get deactivated post 6 months. However, this access can be extended upon request free of charge.

Can I download the recordings?

No. Our recordings can be accessed through your account on LMS or stream them live online at any point of time though.

Recordings are integral part of AnalytixLabs intellectual property by Suo Jure. The downloading/distribution of these recordings in anyway is strictly prohibited and illegal as they are protected under copyright act. Incase a student is found doing the same, it will lead to an immediate and permanent suspension in the services, access to all the learning resources will be blocked, course fee will be forfeited and the institute will have all the rights to take strict legal action against the individual.

What if I share my LMS login details with a friend?

The sharing of LMS login credentials is unauthorized, and as a security measure, if the LMS is accessed by multiple places, it will flag in the system and your access to LMS can be terminated.

Will I get a certificate in the end?

Yes. All our course are certified. As part of the course, students get weekly assignments and module-wise case studies. Based on the selected assignments and case studies (atleast 70%), the certificate shall be awarded.

Do you help in placements?

We follow a comprehensive and a self-sustaining system to help our students with placements. This is a win-win situation for our candidates and corporate clients. As a pre-requisite for learning validation, candidates are required to submit the case studies and project work provided as a part of the course (flexible deadline). Support from our side is continuous and encompasses help in profile building, CV referrals through our ex-students, HR consultants and companies directly reaching out to us.

We will provide guidance to you in terms of what are the right profiles for you based on your education and experience, interview preparation and conducting mock interviews, if required. The placement process for us doesn’t end at a definite time post your course completion, but is a long relationship that we will like to build.

Do you guarantee placements?

No institute can guarantee placements, unless they are doing so as a marketing gimmick! It is on a best effort basis.

In professional environment, it is not feasible for any institute to do so, except for a marketing gimmick. For us, it is on a best effort basis but not time – bound – in some cases students reach out to us even after 3 years for career support.

Do you have a classroom option?

Yes we have classroom option for Delhi-NCR candidates. However, most of our students end up doing instructor led live online classes, including those who join classroom in the beginning. Based on the student feedback, the learning experience is same both in classroom and instructor led live online fully interactive mode.

How can I reach out to someone if I have doubts post class?

Through the LMS, students can always connect with the trainer or even schedule one-to-one time over the phone or online. During the course we also schedule periodic doubts-clearing classes though students can also ask doubts of a class in the subsequent class.

LMS also has a discussion forum where a lot of your doubts might get easily answered.

Incase you are having a problem still, repeat the class and schedule one-to-one time with the trainer.

I am having difficulty coping up with my classes. What can I do?

You can always take one-to-one time with the faculty and get your doubts sorted or take guidance on how you should proceed.

What is your refund policy?

  • Instructor Led Live online or Classroom - Within 7 days of registartion date and latest 3 days before batch start
  • Video-based - 2 days

What are the system requirements for the software?

There is no particular system requirement for this course since the tools required for this course (Excel and SAS) can easily be installed on almost every laptop with basic configuration available these days. However, if possible, it is recommended to have 64-bit operating system.

Can I pay in instalments?

No installment option is available for this course since it is a short course.

How do I attend the online classes? Are they interactive or self-paced?

We provide both the options and for instructor led live online classes we use the gold standard platform used by the top universities across the globe. These video sessions are fully interactive and students can chat or even ask their questions verbally over the VoIP in real time to get their doubts cleared.

What do I need to attend the online classes?

To attend the online classes, all you need is a laptop/PC with a basic internet connection. Students have often shared good feedback of attending these live classes through their data card or even their mobile 3G connection, though we recommend a basic broadband connection.

For best user experience, a mic-headphone is recommended to enhance the voice quality, though the laptop’s in-built mic works fine and you can ask your question over the chat as well.

Super duper amazing classes. They really just clarify all your doubts before moving on to the next part. I took the advance big data science course and I am thoroughly satisfied that I did not take up any other classes, I thought should have taken at the time. They are technically versed in their respective technologies in this case Python - Pandas and Scipy and they just go the distance to clarify all doubts and make things as simple as possible.

- Shikhar Malik (Analytics Associate, G-Square Solutions Pvt Ltd)

Have Questions?
Contact us and we shall
get back with answers.

Change the course of your career

Over 6000 learners and hundreds making right choice every month!
Course Brochure
Upcoming Batches
Student Reviews