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
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