Data Science using SAS (Base + Advance) SAS Base, Proc SQL and Macros

Day 1

  • Overview of SAS System and SAS Tools
  • Different windows in SAS Windows
  • Sample SASprogram
  • DATA step and PROC step
  • SAS Data Libraries
  • Rules for writing SAS programs/Statements/Dataset/Variables
  • Attributes of Dataset –Character and Numeric

Day 2

  • Options (OBS FIRSTOBSNOBS)
  • Input Buffer-Program Data Vector
  • Datalines/cards
  • Creating libraries
  • Proc Print
  • _NULL_ dataset

Day 3

  • Length/Delete/Rename/Sum/Retainstatements
  • Creating multiple datasets from single input SAS dataset
  • Conditionally writing to diffdatasets from a single input dataset -> IF THEN ELSE
  • Vertical sub-setting (IF –WHERE)and Horizontal sub-setting (KEEP –DROP)
  • Proc SORT
  • Functions –SUBSTR–RIGHT–LEFT–SCAN–ROUND –CEIL –FLOOR –INT –SUM –MEAN –MIN –MAX

Day 4

  • FIRST DOT and LAST DOT concept
  • Proc CONTENTS/DATASETS
  • Functions –CAT –FIND –INDEX –LOWCASE –UPCASE –COMPRESS –LENGTH

Day 5

  • DO LOOP-DO WHILE-DO UNTIL
  • SAS Format/In-formats
  • Functions –MDY –TODAY –INTCK –INTNX -YRDIF–PUT –INPUT

Day 6

  • SAS Arrays
  • Proc Format
  • 1-1 MERGE without By variable
  • Match merging –
    1. 1-1
    2. 1-Many
    3. Many-1
    4. Few-Many
    5. Many-Few

Day 7

  • Proc Import
  • Reading raw data(Text and CSV files)
  • LIST Input-Column Input-Formatted Input
  • Use of @,@@ AND Use of /, +
  • Using multiple Input statement with #
  • Use of : modifier to specify and in-format in the input statement
  • Use of DLM, DSD, Miss-over, Truncover, Stop-over
  • Writing to an external file

Day 8

  • Proc Summary
  • The Output Delivery System –ODS
Advance

Day 9

  • Difference in BASE SAS and PROC SQL
  • SELECT –FROM –WHERE -GROUPBY –HAVING –ORDERBY
  • Table alias
  • Sub-setting using Where and Calculated values
  • Use of LABEL –FORMAT

Day 10

  • VALIDATE –NOEXEC –ALTER –CREATE –DELETE –DESCRIBE –DROP–FEEDBACK options
  • COUNT Scenario
  • Dictionary views
  • Sub-Queries –Related and Non-Related

Day 11

  • Joins (Cross –Outer –Inner)
  • Remove duplicate rows
  • Set Operators
  • Similarity and choosing between merges and Joins

Day 12

  • Defining macro and writing SAS Code using Macro -%macro and %mend
  • Replacing text variables using %LET
  • Calling a Macro
  • Macro execution
  • Arithmetic and Logical operators
  • %Include statement
  • Macro Suffix and Prefix

Day 13

  • %Macro with indirect Parametrization
  • %Macro with direct Parametrization
  • %Macro with Proc SQL
  • %Macro with DO LOOPS
  • %Macro with %LOCAL
  • %Macro with %GLOBAL
  • Indirect referencing
  • Macro functions
  • Macro processing –Triggers –how Macro processor works
  • MLOGIC –MPRINT –SYMBOLGEN
  • Macro debugging -%PUT -_all_ -_user_ -_automatic_ -_local_ -_global_