SAS Advanced Programming Training Course

  Part-1 Accessing Data Using SQL
Live Lectures 1-4

  Lecture-1 Generate detail reports in SQL
Live Lecture 
·      Use PROC SQL to perform SQL queries

·      Select columns in a table with a SELECT statement and FROM clause

·      Create a table from a query result set

·      Create new calculated columns

·      Assign an alias with the AS keyword

·      Use case logic to select values for a column

·      Retrieve rows that satisfy a condition with a WHERE clause

·      Subset data by calculated columns

·      Join tables - inner joins, full joins (coalesce function), right joins, left joins

·      Combine tables using set operators - union, outer union, except, intersect

·      Sort data with an ORDER BY clause

·      Assign labels and formats to columns

·      Practical Exercise

  Lecture-2 Generate summary reports in the SQL
Live Lecture 
·      Summarize data across and down columns using summary functions (AVG, COUNT, MAX, MIN, SUM)

·      Group data using GROUP BY clause

·      Filter grouped data using HAVING clause

·      Eliminate duplicate values with the DISTINCT keyword

·      Practical Exercise

  Lecture-3 Construct sub-queries and in-line views
Live Lecture 
·      Subset data by using non-correlated subqueries

·      Reference an in-line view with other views or tables (multiple tables)

·      Practical Exercise

  Lecture-4 Use SAS SQL procedure enhancements
Live Lecture 
·      Use SAS data set options with PROC SQL (KEEP=, DROP=, RENAME=, OBS=)

·      Use PROC SQL invocation options (INOBS=, OUTOBS=. NOPRINT, NUMBER)

·      Use SAS functions (SCAN, SUBSTR, LENGTH)

·      Access SAS system information by using DICTIONARY tables (members, tables, columns)

·      Use the CALCULATED keyword

·      Practical Exercise

  Part-2 Macro Processing
Live Lecture 5-9

  Lecture-5 User-defined and automatic macro variables
Live Lecture 
·      Define and use macro variables

·      Use macro variable name delimiter. (.)

·      Use INTO clause of the SELECT statement in SQL to create a single variable or a list of variables

·      Use the SYMPUTX routine in a DATA Step to create a single variable or a list of variables

·      Control variable scope

·      Practical Exercise

  Lecture-6 Automate programs by defining and calling macros
Live Lecture 
·      Define a macro using the %MACRO and %MEND statements

·      Calling a macro with and without parameters

·      Document macro functionality with comments

·      Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements

·      Use the SAS AUTOCALL facility to permanently store and call macros

·      Practical Exercise

  Lecture-7 Use macro functions
Live Lecture 
·      Use macro functions. (%SCAN, %SUBSTR, %UPCASE)

·      Use macro quoting functions. (%NRSTR, %STR)

·      Use macro evaluation functions. (%SYSEVALF)

·      Use %SYSFUNC to execute DATA step functions within the SAS Macro Language

·      Practical Exercise

  Lecture-8 Debug macros
Live Lecture 
·      Trace the flow of execution with the MLOGIC option

·      Examine the generated SAS statements with the MPRINT option

·      Examine macro variable resolution with the SYMBOLGEN option

·      Use the %PUT statement to print information to the log

·      Practical Exercise

  Lecture-9 Data-driven programs using SAS Macro Language
Live Lecture 
·      Create a series of macro variables

·      Use indirect reference to macro variables. (&&, etc.)

·      Incorporate DICTONARY tables in data driven macros

·      Generate repetitive macro calls

·      Practical Exercise

  Part-3 Advanced Techniques
Live Lectures 10-13

  Lecture-10 Process data using 1 and 2 dimensional arrays
Live Lecture 
·      Define and use character arrays

·      Define and use numeric arrays

·      Create variables with arrays

·      Reference arrays within a DO loop

·      Specify the array dimension with the DIM function

·      Define arrays as temporary arrays

·      Load initial values for an array from a SAS data set

·      Practical Exercise

  Lecture-11 Process data using hash objects
Live Lecture 
·      Declare hash and hash iterator objects

·      Dataset argument

·      Ordered argument

·      Multidata argument

·      Use hash object methods

·      definekey()

·      definedata()

·      definedone()

·      find()

·      add()

·      output()

·      Use hash iterator object methods

·      first()

·      next()

·      last()

·      prev()

·      Use hash objects as lookup tables

·      Use hash objects to create sorted data sets

·      Use hash iterator objects to access data in forward or reverse key order

·      Practical Exercise

  Lecture-12 Use SAS utility procedures
Live Lecture 
·      Specify a template using the PICTURE statement within the FORMAT Procedure

·      Specify templates for date, time, and datetime values using directives

·      Specify templates for numeric values using digit selectors

·      PICTURE statement options: round, default, datatype, multiplier, prefix

·      Create custom functions with the FCMP procedure

·      Create character and numeric custom functions with single or multiple arguments

·      Create custom functions based on conditional processing

·      Use custom functions with the global option CMPLIB=

·      Practical Exercise

  Lecture-13 Use advanced functions
Live Lecture 
·      Finding strings or words with the FINDC/FINDW functions

·      Counting strings or words with the COUNT/COUNTC/COUNTW functions

·      Retrieve previous values with the LAG function

·      Regular expression pattern matching with PRX functions

·      Practical Exercise

  Case Studies