SAS for Data Analytics

Course Overview

Course Description:

SAS provides a comprehensive environment for end-to-end data analytics, from data preparation to modeling, analysis, and reporting. It has been widely adopted in industries such as finance, healthcare, marketing, and government where robust analytics and data management capabilities are required.

Course Duration: 4 weeks (20 sessions(2hours each session))

Week 1

1. Getting Started with SAS

1. Introduction to SAS programs 
2.  Submitting a SAS program    
3.  How to Execute SAS program 
4.  Mastering fundamental concepts    
5. Diagnosing and correcting syntax errors 

2.Getting Familiar with SAS Data Sets

1.  Examining descriptor and data portions 
2.  Accessing SAS data libraries(SET)     
3. Accessing relational databases(IMPORT CSV,EXCEL)   
4. EXPORT the Data     

3. Reading SAS Data Sets            

1.  Introduction to reading data 
2.  Using SAS data as input
3. Subsetting observations and variables

                          

4.Reading Delimited Raw Data Files  

1.  Using standard delimited data as input  
2. Validating data with the PRINT and FREQ procedures(PROC PRINT and FREQ)  
3. Manipulating Data   
4.  Creating variables   
5. Creating variables conditionally  
6. Define Elicitation     
7. Types of Elicitation Techniques

Week 2

5.Combining SAS Data Sets  

1. Introduction to combining data sets  
2.  Appending a data set
3.  Merging data sets one-to-one

6.Character function 

1.  Splitting and joining strings(TRIM,SCAN)
2. Splitting and joining strings(concatenate,substr)
3.  Characracter function(upcase,lowcase,proper case)
4. Compress and Compbl function 

7.Mathematical function in SAS

1.  Max function
2. Min function 
3. Ranuni function
4. Sqrt function

8.Date Function     

1. Date Function(datediff)  
2. Itnck Function
3. Itnx Function 

9.Stastical Function  

1. Proc Means(Mean,Mode,Median,Variance,Standard Deviance)
2.  Proc Univariate(Descriptive Statistics)
3.  Summary Reports    
4.  Proc Freq(creating Reports)  
5.  Tabulate     

10.SAS/GRAPH 

1.  Bar and pie charts   
2.  scatter charts
3.  column chart
4.  Creating plots
5.  Enhancing output

Week 3

11. Data Transformations

1. Manipulating character values
2. Manipulating numeric values 
3. Converting variable type     

12. Debugging Techniques

1.  Using the PUTLOG statement
2.  Using the DEBUG option     

13. Processing Data Iteratively  

1.   DO-loop processing
2.  SAS array processing 
3.  Using SAS arrays     
4. Decision making     
5. IF_THEN_ELSE function  

14.Restructuring a Data Set  

1. Rotating with the DATA step  
2. Using the TRANSPOSE procedure

15.ODS(Output Delivery System)            

1. Converted Output in PDF
2. Converted Output in Word
3. Converted Output in HTML

Revise Whole Base SAS  

                                         Advance SAS 

Week 4

16.Controlling I/O Processing and Memory  

1.  Controlling I/O 
2.  Controlling data set size     
3. Compressing SAS data sets   
4.  Controlling memory  
5. Controlling the page size and the number of available buffers  

17.Introduction to Lookup Techniques  

1.  Introduction to lookup techniques   
2. In-memory lookup techniques   
3. Creating and Using Formats
4.  Using formats as lookup tables 
5. Using a picture format       
6. DATA step merges and SQL procedure joins
7. Using an index to combine data 
8. Using Hash Table for Lookup

18. Introduction to SQL joins 

1. Proc Sql
2. Complex SQL joins    
3. Setting SQL procedure options
4. 19.Introduction to the Macro
5. Macro Variables
6. Macro functions      
7. Global and local symbol table 
8. Call SYMPUT 

20.Set Operators    

1. Introduction to set operators 
2. The EXCEPT operator 
3.  The INTERSECT operator     
4. The UNION operator  
5.  The OUTER UNION operator  

                          

Revise Whole Advance SAS