Base SAS Certification
Chapter 1: Introduction
Chapter 2: Getting started with SAS
1
Introduction to SAS programs
2
Submitting a program
3
Exercises /quiz
Chapter 3: Working with SAS Syntax
1
Mastering Fundamental Concepts
2
Diagnosis and Correcting syntax errors
3
Exercises
Chapter 4: Getting familiar with SAS Datasets
1
Understanding the PDV Process
2
Accessing sas data libraries and Relational databases
3
Exercises
Chapter 5: Reading SAS Datasets
1
Introduction to Reading Data
2
Using SAS Data as Input
3
Subsetting Observations variables
4
Adding permanent attributes
5
Exercises
Chapter 6: Reading excel worksheets
1
Using excel data as input
2
Reading excel worksheets
3
Exercises
Chapter 7: Reading delimited raw data files
1
Using standard delimited data as input
2
Using NON standard delimited data as input
3
Exercises
Chapter 8: Validating and Cleaning data
1
Introduction to Validating and Cleaning data
2
Examining data errors when reading raw datafiles
3
Validating data with print and freq procedure
4
Validation data with means and Univariate procedure
5
Cleaning invalid data with windows and UNIX
6
Using FSEDIT window to clean the data
7
Exercises
Chapter 9:Manipulating the data
1
Creating variables
2
Creating Varibles conditionally
3
Subsetting observations
4
Excersises
Chapter 10: Combining the sas datasets
1
Introduction to Combining the datasets
2
Appending the sas datasets
3
Concatenation of sas datasets
4
Merging the sas datasets [One to one / One to many ]
5
Merging datasets with Non-Matches
6
Exercises
Chapter 11: Enhancing the Reports
1
Using global statements
2
Adding labels and formats
3
Creating used defined formats
4
Subetting and Grouping Observations
5
Direct output to the external files HTML /PDF/EXCELXP/RTF
6
Exercises
Chapter 12: Producing summary reports
1
Using Freq Procedure
2
Using means procedure
3
Using Tabulate Procedure
Chapter 13 : Controlling input and output
1
Output multiple observations
2
Writing to multiple sas datasets
3
Selecting variables and Observations
4
Writing to an external file
5
Exercises
Chapter 14 : Summarizing Data
1
Creating and Accumulating total variables
2
Accumulating totals for a group of data
3
Exercises
Chapter 15 : Reading and writing different types of data
1
Reading Delimited rawdata files
2
Controlling when a record loads
3
Reading hierarchical rawdata files
4
Exercises
Chapter 16: Transformations
1
Introduction
2
Manipulating character values
3
Manipulating Numeric Values
4
Manipulating Numeric values based on Dates
5
Converting variable type
6
Exercises
Chapter 17 : Debugging Techniques
1
Using PUT Statement
2
Debug Option
Chapter 18 : Processing data iteratively
1
DO Loop Processing
2
SAS Array Processing
3
Using SAS Arrays
4
Exercises
Chapter 19: Combining the sas datasets
1
Match merging two or more sas datasets
2
Simple joins using sas sql procedure
3
Exercises
Productivity Hacks to Get More Done in 2018— 28 February 2017Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!