Introduction to the Analytics world and SAS role



Analytics World

  • Introduction to Analytics
  • ETL CONCEPT and role of SAS in ETL
  • SAS in advanced analytics
  • SAS Certification: Induction and walk through

Getting Started with SAS

  • SAS software installation
  • Introduction to SAS, GUI
  • Different components of SAS language
  • All SAS programming windows
  • Concept of SAS Libraries and Creating Libraries
  • Variable Attributes - (Name, Type, Length, Format, In format, Label)
  • Importing Data and Entering data manually

Understanding Datasets

  • Descriptor Portion of a Dataset (Proc Contents)
  • Data Portion of a SAS Dataset
  • Variable Names and Values
  • SAS Data Libraries

SAS:Accessing the data


Understanding Data Step processing

  • Data Step and Proc Step
  • Data step execution
  • Compilation and execution phase
  • Input buffer and concept of PDV

Importing Raw Data files

  • Column Input and List Input and Formatted methods
  • Delimiters, Reading missing and non standard values
  • Reading one to many and many to one records
  • Reading Hierarchical files
  • Creating raw data files and put statement
  • Formats / Informat

Importing and Exporting Data (Fixed Format / Delimited)

  • Import Wizard
  • Proc Import / Delimited text files
  • Proc Export / Exporting Data from SAS
  • Datalines / Cards
  • A typical importing cases (mixing different style of inputs)
  • Reading Multiple Records per Observation
  • Reading “Mixed Record Types
  • Sub-setting from a Raw Data File
  • Multiple Observations per Record
  • Reading Hierarchical Files
  • Importing Tips

SAS : Data Understanding, Managing and Manipulation


Understanding and Exporing Data

  • Introduction to basic Procedures - Proc Contents, Proc Print
  • Operators and Operands
  • Conditional Statements (Where, If, If then Else, If then Do and select when)
  • Difference between WHERE and IF statements and limitation of WHERE statements
  • SAS Labels, Commenting
  • SAS System Options (OBS, FSTOBS, NOOBS etc…)

Data Manipulation

  • Proc Sort - with options / De-Duping
  • Accumulator variable and By-Group processing
  • Explicit Output Statements
  • Nesting Do loops
  • Do While and Do Until Statement
  • Array elements and Range

Combining Datasets (Appending and Merging)

  • Concatenation
  • Interleaving
  • Proc Append
  • One To One Merging
  • Match Merging
  • IN = Controlling SAS merge and Indicator

SAS : Functions

  • General form of SAS Functions
  • Arithmetic Functions
  • Date and Time Functions
  • Text Manipulation Functions
  • Nested Functions

SAS: Data Analysis & Reporting

  • Proc Freq
  • Proc Format for user defined formats
  • Proc Means
  • Proc Summary
  • Proc tabulate
  • Proc report
  • Concept of the Output Delivery System
  • Using ODS Statements to save data on external destination

Advance SAS -Data Mining with Proc SQL

  • Introduction to Proc SQL
  • Basics of General SQL language
  • Creating table and Inserting Values
  • Retrieve & Summarize data
  • Group, Sort & Filter
  • Using Joins (Full, Inner, Left, Right and Outer)
  • Reporting and summary analysis
  • Concept of Indexes and creating Indexes (simple and composite)
  • Connecting SAS to external Databases
  • Implicit and Explicit pass through methods

Advance SAS - SAS Macros

  • Global and Local Variables
  • Macro Parameters and Variables
  • Different types of Macro Creation
  • Defining and calling a macro
  • Using call Symput and Symget
  • Macros options (mprint symbolgen mlogic merror serror)

Working smartly with SAS


Debugging SAS

  • How to read log file efficiently
  • Tips to debug code

Efficient SAS Programming

  • Code optimization and Efficient SAS Programming Techniques
  • Saving CPU Time, I/ O processing time
  • Disk Space Saving Measures
  • Memory saving tips

List of Procedures covered

  • Proc Import
  • Proc Export
  • Proc Contents
  • Proc Datasets
  • Proc Copy
  • Proc Delete
  • Proc Print
  • Proc Append
  • Proc Sort
  • Proc Format
  • Proc Transpose
  • Proc Means
  • Proc Summary
  • Proc Freq
  • Proc Tabulate
  • Proc Report
  • Proc Options
  • Proc SQL