Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
SASCrunch Membership

Get instant access to all learning materials for just $39.99/month (regular price: $59.99/month)!

Membership includes:
  • All four complete training courses with 36 combined modules
  • 300+ coding exercises and instant solutions
  • 100+ sample exam questions
  • Real-time learning support​
  • 7-day money-back guarantee​
Sign up for Membership
Risk-Free 7-day 100% money-back guarantee

Get Access to Four SAS Training Courses for the Price of One!

SASCrunch membership gives you access to the four courses below:

SASCrunch Practical SAS Training Course for Beginner​s
Description

SASCrunch Practical SAS Training Course for Beginners is an interactive SAS training course that allows you to learn and practice SAS at the same time and on the same screen.

It includes 7 complete modules with 150+ coding exercises and 5 coding projects.

You can learn SAS from scratch and become an intermediate SAS programmer in just 30 days.

Highlights
  • 7 modules
  • 150 exercises
  • 5 projects
  • 1000+ projects submitted
  • 7-day money back guarantee
Course Outline
Module 0: How to start
  • Set up the training

Module 1: SAS Interface
  • Code Tab
  • Log Tab
  • Error and Warning Message
  • Library
  • Data Set
  • Summary
  • Final Test
  • End of Module

Module 2: Data Set
  • Create a Data Set
  • Programming Tips #1
  • Programming Tips #2
  • Character Variable
  • Creating Multiple Observations
  • Programming Tips #3
  • Character Variable II
  • Data Truncation
  • Copying Data Set
  • Subsetting Data Set
  • Assessing Other Libraries
  • Programming Tips #4
  • Accessing your Own Data Set I
  • Accessing your Own Data Set II
  • Saving a Data Set
  • Exporting Data Set I
  • Exporting Data Set II
  • Exporting Data Set III
  • Summary
  • Final Test
  • Coding Project
  • End of Module

Module 3: SAS Functions
  • Mathematical Operators
  • Programming Tips #5
  • SUM Function
  • MEAN, MIN and MAX Functions
  • RAND Function
  • ROUND Function
  • FLOOR Function
  • SUBSTR Function
  • LENGTH Function
  • Combining Character Variables
  • INDEX Function
  • INDEXC Function
  • UPCASE, LOWCASE and PROPCASE Functions
  • RENAME, KEEP and DROP Statements
  • If-then statement
  • Summary
  • Final Test
  • Coding Project
  • End of Module

Module 4: Variable Attributes
  • The 6 Attributes of SAS Variables
  • Proc Contents
  • Programming Tips #6
  • Attribute #1: Variable Name
  • Attribute #2: Variable Label
  • Attribute #3: Variable Type (Numeric)
  • Attribute #3: Variable Type (Character)
  • Attribute #4: Variable Length
  • Attribute #5: Variable Format
  • Programming Tips #7
  • The Format of W.D
  • Comma. and Dollar. Format
  • Understand how SAS keep track of Date and Time
  • Date & Time Format
  • Creating your own format
  • (Best.) Format
  • Summary of Variable Formats
  • PUT Function
  • INPUT Function
  • Programming Tips #8
  • Summary
  • Final Test
  • End of Module

Module 5: Data Manipulations
  • Sorting the Data Set
  • Creating Output Data Set
  • Programming Tips #9
  • Removing Duplicate Observations
  • Flagging Extreme Values
  • Flagging Extreme Values II
  • Data Set Concatenation
  • Two (2) common issues when concatenating data sets
  • Merging data sets
  • Identifying the Merging Variable(s)
  • Programming Tips #10
  • Dealing with unmatched observations
  • (In=) Option
  • Transposing Data Set
  • Tips for Proc Transpose
  • Reverse Transpose
  • Variable _n_ and _error_
  • Retain Statement
  • Assigning initial values with Retain Statement
  • (+) Expression
  • Summary
  • Final Test
  • Coding Project I
  • Coding Project II
  • Coding Project III
  • End of Module

Module 6: Data Analysis
  • Proc Univariate
  • Programming Tips #11
  • Normality Test
  • Analyzing Multiple Segments
  • Output Statement
  • Programming Tips #12
  • Proc Means
  • Additional Statistics
  • Classification Variable
  • Programming Tips #13
  • Working with Multiple Analysis Variables
  • Output Statement II
  • Output Data Set
  • Proc Freq
  • Histogram
  • WEIGHT Statement
  • N-way Crosstabulation Table
  • (OUT=) Option
  • Summary
  • Final Test
  • End of Module

Module 7: Hypothesis Testing Using SAS
  • Introduction to Hypothesis Testing
  • One-sample t-test
  • One-sided t-test
  • Paired t-test
  • Two-sample t-test
  • ODS Output
  • Chi-square Test of Independence
  • Correlation Analysis
  • Programming Tips #14
  • Summary
  • Final Test
  • Coding Project
  • End of Training
Fee
Included in SASCrunch Membership ($39.99/month)
Get FREE sample modules

The Ultimate SAS Certified Specialist Exam Prep Course
Description

The Ultimate SAS Certified Specialist Training Program includes two full courses covering each and every topic in the certification exam.

You will be familiar with the exam structure and question styles, with 200+ sample exam questions.
​
This is the only study material you need to achieve a great result on the rigorous certification exam.​

Highlights
  • 2 certificate pre courses
  • 300+ practice exercises
  • Real-time learning support​​
  • 7-day money-back guarantee​
Course Outline
Module 1: Proc Import
  • Data Files - Download​
  • Importing an Excel Spreadsheet
  • REPLACE Option, SHEET and GETNAMES options
  • Importing CSV File
  • Importing Text Delimited File
  • Importing Tab Delimited File
  • Accessing Excel Data using XLSX Engine
  • Creating an Excel Spreadsheet using XLSX Engine
  • Summary
  • Final Test
  • Coding Exercise


Module 2: Debugging Error
  • Syntax Error, Spelling Error, Unbalanced Quote Error
  • Missing Run/Quit Statement, Invalid Option Error
  • Data Error
  • Logic Error
  • Sample Exam Question
  • Summary
  • Final Test
  • Coding Exercise


Module 3: Data Step Processing
  • Quick Review on Data Step
  • Compilation and Execution Phase
  • Code Compilation
  • Input Buffer
  • Program Data Vector (PDV)
  • Initialization of PDV
  • Descriptor Portion of Data Set
  • Execution Phase
  • Reading the Next Record
  • Summary
  • Sample Exam Questions


Module 4: Proc Print
  • Proc Print, VAR Statement, NOOBS Option
  • ID Statement, WHERE Statement, CONTAINS Operator
  • SUM and BY Statement
  • Display Formats, Column Label
  • Summary
  • Sample Exam Questions
  • Coding Exercise


Module 5: Processing By-Groups
  • First.variable and Last.variable
  • Output Statement
  • Cumulative Summation Over By-groups
  • Summary
  • Sample Exam Questions
  • Coding Exercise


​Module 6: Simple Macro
  • Text Substitution
  • %LET Statement, %PUT Statement, Macro Symbol Table
  • Reference Macro Variable
  • Reference Macro Variable II
  • Automatic Macro Variables
  • Summary
  • Final Test
  • Coding Exercise


Module 7: Handling Date Values
  • Date Constant, Time Constant
  • Date Informats
  • Additional Date Informats, Formats
  • DAY, MONTH, YEAR, QTR, MDY, TODAY Functions
  • INTNX Functions
  • INTCK Functions
  • Datetime Variables
  • Summary
  • Final Test
  • Coding Exercise


Module 8: Do-loop: End of July 2019

Module 9: Data Manipulation II: End of July 2019

Module 10: Additional Functions: End of July 2019

Module 11: ODS: End of July 2019
Fee
Included in SASCrunch Membership ($39.99/month)

Introduction to Proc SQL (Part 1)
Description

SASCrunch Proc SQL course (part 1) is an introductory course in the SQL procedure in SAS.

It covers a wide range of topics in Proc SQL with 14 training sections and 20+ coding exercises.

Upon completion of the course, you will be able to efficiently retrieve, manipulate and analyze data using Proc SQL in SAS.

Highlights
  • 28 training modules
  • 200+ sample exam questions
  • Real-time learning support​​
  • 7-day money-back guarantee​
Course Outline
  • Introduction
  • Retrieve Columns
  • Select Multiple Columns
  • Create New Columns
  • Case Expression
  • WHERE Clause
  • WHERE Clause with Calculated Column
  • IN Operator
  • LIKE Operator
  • ORDER BY Clause
  • Summarizing Data
  • Summary Functions
  • Counting Statistics
  • HAVING Clause
  • Subquery
  • Final Test
  • Coding Exercises
  • Coding Exercises (Answers)
Fee
Included in SASCrunch Membership ($39.99/month)

Introduction to Proc SQL (Part 2)
Description

SASCrunch Proc SQL course (part 2) is an advanced SAS programming course focusing on the SQL procedure in SAS.

It covers the different types of joins and SET operators using Proc SQL. You will also learn how to update and modify SAS tables and create integrity constraints using the SQL procedure.

Upon completion of the course, you will be capable of performing complex data manipulations and analysis using one of the most powerful and commonly used procedures in SAS.
Highlights
  • 17 training sections
  • 27+ coding exercises
  • Real-time learning support​​
  • 7-day money-back guarantee​
Course Outline
  • Introduction
  • Cartesian Product
  • Inner Joins
  • Table Alias
  • Inner Join with Summary Function
  • Outer Join
  • Left Outer Join
  • Combine Table Vertically
  • Overlaying Columns
  • Outer Union Set Operator
  • Creating SAS Tables
  • Creating SAS Tables using Query
  • Inserting Rows into Table
  • Updating Tables
  • Altering Columns
  • Deleting Rows and Tables
  • Integrity Constraint
  • Final Test
  • Coding Exercises
  • Coding Exercises (Answers)​
Fee
Included in SASCrunch Membership ($39.99/month)
Sign up for membership
Risk-Free 7-day 100% money-back guarantee

Learn by Doing

You won't truly learn SAS until you start writing your own programs and solving real-life data manipulation problems.

Our interactive SAS training program offers 150+ coding exercises and 5 coding projects with instant solutions.

You will learn how to apply SAS programming concepts and techniques to tackle real-life data manipulation and analytical problems.

SAS Base Certification

Are you looking for a SAS analyst job but you lack the relevant experience?

SAS base certification will give your credentials a huge boost.


Our SAS base certification training course includes 28 training modules and 200+ sample exam questions covering each and every topic of the certification exam.

This is the only course you need to achieve a great result on the exam.​
SIGN UP FOR MEMBERSHIP
Risk-Free 7-day 100% money-back guarantee

Interactive Learning Platform

SASCrunch training is the world's first interactive SAS training program that allows you to learn and practice SAS at the same time and on the same screen.

It is a proven model used by programming learning powerhouses such as Code School, Codecademy and Data Camp.

You will fully understand each concept before moving on to the next topic.

It is the fastest and easiest way to learn SAS on your own.

Real-Time Learning Support
(1-866-809-0390)

Our SAS instructors are one phone call away from answering any questions you have about learning SAS.

Call us at 1-866-809-0390 during our office hours (9-5 EST) and you will be greeted by our SAS instructors in real-time.

We are there to help you when you need us!​

Got a question? Call us at 1-866-809-0390!

7-Day 100% Money-Back Guarantee

​We back up our promises with our 7-day 100% money-back guarantee.

If you aren't satisfied with our course within 7 days of purchase, simply send us an email to [email protected].

You will receive a full refund.

No questions asked.

SIGN UP FOR MEMBERSHIP
Risk-Free 7-day 100% money-back guarantee

This course is for:

Job Seekers
with no prior experience in the field of data analytics


Students
in MBA, Statistics, Math or Economics programs


Business Owners
looking for SAS training for staff


Mid-Level Managers
who need to communicate with technical staff

SIGN UP FOR MEMBERSHIP
Risk-Free 7-day 100% money-back guarantee

Our students like our program so much that they are willing to put their names on our website to support us.

Credit Analyst
(Testimonial #1)
Picture

​"The training that I got here was extremely helpful. The process of training was simple and the content was explained crystal clear. The test was amazing and I will gladly recommend SASCrunch.com to anyone, especially to beginners and mid-level SAS aspirants. Their SAS information is very easy to grasp."

Neeraj Tiwari
Credit Risk Analyst
BrickWork Ratings 

Master Student
(Testimonial #2)
Picture

"This program has an excellent course content that I have ever come across. It is easy to understand and I found it to be the easiest way to learn and even code SAS. The topics discussed are thoroughly covered, and I appreciated how they use clear illustrations to explain. One thing that really helped me to be more serious and concentrate was the real time assignments offered. The coding assignments are well drafted and informative, they will make you think about every concept you have learned all through the training. I also observed that the coding scenarios used in the illustrations are very similar to what we have in a real-time environment and hence are very relevant and eye opening. The greatest thing is the constant support you receive from the trainer just in case you are stuck in any part of the training. It was great to be a part of it. Happy Learning!!"

Anusha Rathore
Master Student in Business Analytics & Project Management
University of Connecticut

Data Analyst
(Testimonial #3)
Picture

"Fantastic! I never had knowledge about SAS programming. This is simply a wonderful start up tutorial. It is very informative and descriptive to the point. After getting the online training from SASCrunch.com, I have learnt a lot of things regarding SAS programming. It helps me a lot to become a SAS user and I am confident I can start up my new career as a SAS Programmer thanks to SASCrunch.com. I can assure you that you will make one of the best decisions in your life if you join their training."

Gopi Das
Data Analyst
Ipsos Canada

Banker
(Testimonial #4)
Picture

"I was looking for something that could clearly show me the Concepts of SAS at my own pace, SASCRUNCH was exactly what I needed. The Modules given flow seamlessly into each other and I like the fact that you are actually challenged after each concept to ensure that you have mastered that specific piece. The split screen approach works very well and I am able to do it every time I have some idle time at work. After module 4, I was starting to have conversations with experienced SAS Coders and they were very impressed with the speed at which I had learned concepts. I cannot wait to finish the training. It is empowering stuff and yet the simplicity and clarity of contents followed by the tests is unbelievable. I would like to recommend SASCrunch.com to everybody, and for beginners like me, this is the best place to get tutorials."

Hanno Zeeman
Capital and Balance Sheet Management
ABSA Bank

Sign up now
Risk-Free 7-day 100% money-back guarantee

IT Analyst
(Testimonial #5)
Picture

"I went through the study materials provided and I found them very useful. It was my first time with SAS and I understood every bit of the training. I really liked how their SAS training is linked to the current business world, given that it is vital to understand the recent trends. I understood data analytics and data manipulation among other topics to a level I never imagined I could. If you are looking forward to studying the best SAS that is relevant and applicable in real time business solutions, this is the place to get the best informative training."

Vrindha Ganesan
IT Analyst
Tata Consultancy Services

University Teaching Assistant
(Testimonial #6)
Picture

​"SASCrunch Training Modules are a great way to learn SAS programming. They are very practical. The modules do not only give me knowledge of the SAS programming language, but they also give me some very practical insights about how to do real-life projects at work. I learned SAS before by reading books, but I found it very difficult. These training modules make learning much easier. They really work."
​

Yang Fang
Teaching Assistant
York University

University Student
(Testimonial #7)
Picture

"The tutorials provide an excellent framework for fundamental programming; and the projects at the end of each chapter are excellent for additional practice, while also providing a glimpse into what the daily life of an SAS programmer might resemble.

As a college student looking for future career opportunities, I saw that experience with SAS programming was appearing on numerous job applications, and my university did not offer a course as part of my degree requirements. Thankfully SASCrunch.com provided excellent instruction to help my initial setup, in addition to a great beginner introduction before leading into more intermediate projects.

The only noticeable downside I have come across is that I wish there would be a certification of completion offered at the end of the course. However, they do offer a guarantee with their training - with the addition that any questions or problems will be answered in a 24 hour period. This support is very convenient for those times when you do not exactly understand a concept or an error. Overall, it has been an excellent experience and I look forward to continuing their courses!"

 
Christopher Richey
University of Alabama
Mathematics and Statistics

Sign up now
Risk-Free 7-day 100% money-back guarantee

FAQ #1
Will the SAS training help with my job search?
Picture

Absolutely.

SAS is widely used in health care, marketing, banking, social research and academics.

This training will teach you all the SAS programming skills as well as the data manipulation and statistical analysis techniques needed to tackle real-life problems from multiple industries.

You will be able to handle the programming needs that are often required by your potential employers.

Sign up now
Risk-Free 7-day 100% money-back guarantee

Already a member? Go to member's area.