home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
SAS programming part 2: digging deeper

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, 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 SQL 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

datelanguageplacepriceremarks
06/06/2012 Leuven1260 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

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