SAS programming part 2: digging deeper

During this training, we will dive deeper in the SAS programming language. In this three-day ABIS course, we will go more in depth on the data step (also to improve performance). We will have a look at the usage of SQL in SAS, and will create modern reports and graphs.

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.

Schedule a training?

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.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

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

Background

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.

You can test for yourself to see whether you have sufficient SQL background by filling out the online self-test "SQL fundamentals".

Main topics

  • 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

Training method

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.

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration

3 days.

Course leader

Sandy Schillebeeckx (ABIS).


SESSION INFO AND ENROLMENT