Crash Course : SAS Programming from Scratch with workout
About Course
Learn SAS programming from industrial usage perspective. SAS is one of the most used tool for data science, analytics and statistical analysis domain. This course is designed to give you good start on SAS programming quickly. The course has following highlights
 Getting free access to SAS
 Importing data
 Getting basic feel of data through contents, print, freq, univariate
 Data operations like merge, append, sort, truncate – rows / columns wise,
 derive new fields,
 analysis for each class
 Graphs – vertical bar chart / pie charts / stacked charts
 Statistical procedure
 Title and labels for enhancements
 Tabulate for pivot table kind of work
 Putting together analysis with ODS HTML and colorful title
 proc transpose to transpose the data
 proc compare to compare datasets
The course content in detail is as follows
———————————————————————————
Section 1 : Getting access to SAS and understand SAS environment
———————————————————————————
 Getting free access to learn SAS
 Get familiar with SAS environment
Understand what is
 Program editor
 Log window
 Output window
 Library etc.
———————————————————————————
Section 2 : Most used data operations in SAS
———————————————————————————
 Get familiar with the Data for workout
 Import data in SAS
 Viewing Meta Data
 Viewing Data
Understand various options to print
 Few records starting from a particular observation
 Few columns / all columns
 precaution
 Direct data entry in SAS
 How to be careful for character format
 Frequency Distribution for categorical variables
Understand
 Various parts of the output
 Default and quantity based sorting order
 Storing proc freq output into a SAS dataset
 Why one should avoid proc freq for numeric variable
 Numeric Variable Analysis
Understand
 Proc Univariate and Proc Means
 Advantages of both the approaches
 Requesting few statistics only in the output
 Sorting Data
Understand
 How to sort on the basis of one variable / two variables
 How to keep original data as it is and store sorted data in a new dataset
 How to sort data in descending order
 How to remove duplicates
 What is first. and last. option and how to use it
 Merging n Dealing with missing data
Understand
 What is merging data
 What are the Pre requisites of merging data
 What is left join, right join and equi join
 How to do various kinds of join
 How is missing value represented for numeric and character variable
 Syntax for replacing missing value for a numeric variable
 Syntax for replacing missing value for a character variable
 Appending datasets
Understand
 What is appending datasets?
 How to append data?
 What happens when datsets have different columns and still you want to append it?
 Derive New field
 Write if else logic to create a derived field
 Learn to use OR operator
 Understand how to define length for proper display of variable
 Arithmetic Logical n comparison Operators
 Get to know the different Arithmetic, Logical and Comparison operators we have
 Demo of how to use them for the whole data set
 Also see how to keep only those records, which meets certain criteria
 Truncating data rows n columns wise
 Learn how to keep or drop few fields from a given dataset
 Learn to keep or delete few records meeting certain criteria
 Part of string using Substr
 Understand the syntax for substring
 See the workout example
 in operator
 Understand the usage of in operator
 See the demo to understand how does it make it easy to compare multiple string in one go
 CrossTab using SAS
Understand
 How to create cross tab in SAS?
 How to interpret the output
 How to supress some statistics from the result?
 Numeric Variable Analysis for each class
 Understand how to conduct analysis for each distinct value of a particular categorical variable easily using class statement
 dealing with dates
 Understand date 9 format
 The usage of mdy function to create date
 Find days / years spend between two dates
 Use round function to get nicely formatted value
 Proc SQL n Fetching data from database
 Understand the utility of Proc SQL
 Understand the process of getting data from databases using proc SQL
———————————————————————————
Section 3 : Statistical procedures and report enhancements
———————————————————————————
 Conducting linear regression analysis using SAS
 Understand how to conduct linear regression analysis using SAS
 How to get the regression equation, coefficient of determination etc.
 How to interpret coefficient of determination
 How to make out, it is a positive or negative relationship
 Conducting Chi square analysis using SAS
 Understand how to get chi square statistics for contingency table
 How to make sense of degree of freedom, chi square statistics, p value etc.
 Conducting one way ANOVA analysis using SAS
 Learn the syntax of ANOVA analysis using SAS
 Learn to interpret the box plot appearing with ANOVA analysis
 Learn to make sense of p value of ANOVA
 Graphs in SAS
Learn to
 Create vertical bar chart
 Create horizontal bar chart
 How to get just the percentage or freq, percent all
 How to create stacked bar chart (where bars of numeric variable can show distribution of a categorical variable)
 How to create a pie chart
 Difference between proc gchart and proc chart
 How to create chart of a numeric variable for each class separately
 Title and Label
 How to put specific title above the print / graph output etc.
 How does title 1 and title 2 differ
 What is label
 What is the use of these title and label statement
 Proc tabulate – pivot table in SAS
 Understand the syntax of proc tabulate
 See proc tabulate and Excel pivot table side by side
 ODS HTML to package the output and rich text title (bold, colorful)
 Proc transpose to transpose the data
 Proc compare to compare datasets
————————
Section 4 – Practice Case Studies – apply your knowledge to solve business problems
Course Content
Introduction to the course and getting ready to work on SAS

Introduction to the course content
00:00 
Getting free access to SAS
00:00 
Understand SAS environment
00:00 
How to get best out of the course
00:00