About ABIS
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data and AnalyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
SAS programming part 2: digging deeper

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. The course content is based on a selection of SAS coding techniques for reporting that are very often used by most companies that implement the SAS product.

At the end of this course, participants will be able:

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


datedur.lang.  location  price
09 Apr3?Leuven  (BE)1350 EUR  (excl. VAT) 

Intended for

Analysts, programmers, info-center support and experienced end-users. This course is suitable for both PC and mainframe users. Although "SAS on mainframe" is used in the labs, "SAS on Windows" is available for those delegates that never work in a mainframe terminal session. The statements and commands, as well as the context discussed are the same on all platforms.


Delegates should have followed the course SAS programming part 1: fundamentals or should have equivalent experience, and they also should not be afraid of writing code. 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.

Main topics

Dimensions • Class • Layout

Layout • Column • Define

Array • coding loops • creating PUT logic • efficiency and performance • nested dataset reading

SAS Data Step and Proc Step alternatives • Join • External relational data: view, passthrough, libname • the SAS part of SQL

The SAS ODS panels • export of SAS output to SAS data sets, HTML pages or flat files

Concept • graphical features • PROC GCHART • PROC GPLOT • PROC GMAP

Training method

Instruction using overhead visuals combined with demonstrations and exercises on SAS mainframe and SAS PC. A lot of time is spent on doing exercises. Participants are allowed to bring personal programmes with them.


3 days.

Course leader

Koen De Backer, Sandy Schillebeeckx.

Global score

4.2/5 (based on 16 evaluations)


goede combinatie met gebruik op werkvloer (, )
zeer goed uitgelegd (, )
super intéressant (, )
bonne (, )