This course is an extension to the 3-day course SAS programming part 1: fundamentals. Multiple scenarios for building reports are compared based on more specialised procedures, more intelligent code and specialised SAS Base features. 

In this course, participants will learn to:

• exploit more intelligent logic in the data step and keep an eye on performance
• use more specialised options in SAS procedures
• use PROC SQL as an alternative for classic SAS code
• link a SAS program to a RDBMS
• write modern reports via SAS ODS
• use the basic SAS GRAPH procedures

If you want to write reusable SAS modules, see also SAS programming part 3: macro essentials.

• Advanced Data Step Programming
  • data set options
  • loops and select: extra options
  • arrays
  • functions across observations
  • branching
  • multiple set statements
  • %include
• Using SQL in SAS
  • proc sql
    • select, from, where, group by, having
    • join
    • functions and case
    • insert/update/delete
    • create table
  • sas dictionary tables
  • linking to RDBMS
    • libname statement
    • SAS passthrough facility
• Advanced Procedures
  • Revisited: proc sort (equals/noequals, sortseq, linguistic sorting) and  proc format (creating reusable formats)
  • Data sampling
• SAS system extras
  • system options
  • debugging
• Performance
  • mechanism of the data step
  • temporary arrays
  • using indexes
  • views
  • data compression
• Creating Modern Reports
  • proc transpose and proc tabulate
  • SAS ODS: output to excel, pdf, html5
  • using Enterprise guide options
• SAS Graph
  • gchart
  • sgplot
  • sgpanel
  • sgscatter

Classroom training using demos. A lot of time is spent on doing exercises. SAS enterprise guide will be used as IDE, but on demand also z/OS mainframe could be used.

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Participants should have followed the course SAS programming part 1: fundamentals or should have equivalent experience. The PROC SQL part of the course requires a good working knowledge of at least the basic SQL query; if not then first enrol for the course SQL and relational databases fundamentals.

Analysts, programmers, info-center support and experienced end-users.