home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » 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

Objectives

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:

  • to apply PROC Tabulate creatively;
  • to apply PROC Report creatively;
  • to exploit more intelligent logic in the data step and keep an eye on performance;
  • to use PROC SQL as an alternative for classic SAS code;
  • to consult data in external databases with PROC SQL;
  • to understand and use the SAS ODS principles;
  • to adapt the basic Graph procedures (PROC GPLOT, PROC GCHART and PROC GMAP).

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

Main topics

  • PROC Tabulate and PROC Transpose:

Dimensions • Class • Layout

  • PROC Report:

Layout • Column • Define

  • DATA STEP coding revisited:

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

  • PROC SQL:

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

  • SAS ODS:

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

  • PROC GCHART/GPLOT/GMAP:

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

 

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.

Background

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.

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.

Course leader

Koen De Backer, Sandy Schillebeeckx.

Duration

3 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
14 Jun3?Leuven  (BE)1350 EUR  (excl. VAT) 
18 Oct3?Leuven  (BE)1350 EUR  (excl. VAT) 

Global score

   
4.2/5 (based on 16 evaluations)

Reviews

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