Data Science with SAS

Introduction and History of SAS 

Significance of SAS software solutions in various industries 

Demonstrate SAS Capabilities 

Job Profile / career opportunities with SAS worldwide? 

Explore SAS Windowing Environment 

SAS Tasks 

Working with SAS Syntax 

Create and submit a SAS sample program 

Accessing SAS Data libraries 

Getting familiar with SAS Data set 

Introduction to reading data 

Examine structure of SAS data set 

Understanding of SAS works 

Using Excel data as input 

Create as sample program to import and export excel sheets 

Introduction to raw data 

Reading delimited raw data file (List Input) 

Using standard delimited data as input 

Using nonstandard delimited data as input 

Reading raw data aligned to columns (Fixed or column input) 

Reading raw data with special instructions (Formatted input) 

Write data values from SAS data set to an external file 

Create multiple output datasets from single SAS dataset 

Writing observations to one or more SAS datasets 

Controlling which observations and variables to be written to output data 

Where condition 

Conditional processing using: IF statements 

Iterative DO loop processing with END statement 

DO WHILE & DO UNTIL Statement 

SAS Array statement 

Creating and Accumulating total variable (Retain) 

Using Assignment statement 

Accumulating totals for a group of data (BY group) 

Sorting SAS data sets 

Manipulating SAS data values 

Presentation of user defined values /data/currency values using FORMAT procedure 

SAS functions to manipulate char and num data 

Convert data type form char-to num and num-to-char 

SAS variables lists/ SAS variables lists range 

Debugging SAS program 

Accessing observations by creating index 

Rotating with the data step 

Using the transpose procedure 

Concatenation 

Interleaving 

One to one reading 

One to one merging (with non-matching) 

Match merging (Merging types with IN=option) 

Validating and cleaning data 

Detect and correct syntax errors 

Examining data errors 

SAS/REPORTS SAS/GRAPH 

SAS/STATS SAS/ODS 

Freq Report 

Means Report 

Tabulate Report 

Proc report 

Summary report 

Univariate report 

Contents report 

Print report 

Compare proc 

Copy proc 

Datasets proc 

Proc append 

Proc delete 

Regression proc 

Uni/Multivariate proc 

Anova proc 

Producing Bar and Pie charts (GCHART Proc) 

Producing plots (GPLOT Proc) 

Presenting Output Report result in: 

PDF 

Text files 

Excel 

HTML Files 

Introduction and overview to SQL procedure 

Proc SQL and Data step comparisons 

Proc SQL syntax overview 

Specifying columns/creating new columns .