SAS Fundamentals - Part 2


This course builds on the subjects taught in the 3-day course 'SAS Fundamentals - Part 1'. 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. .

This course is available for one-company, on-site presentations.

Objectives

On successful completion of this course you will be able to:

  • apply PROC Tabulate creatively
  • apply PROC Report creatively
  • apply the FSP procedures and commands and their options
  • use PROC SQL as an alternative to classic SAS programming
  • consult data in external databases with PROC SQL
  • understand and use the SAS ODS principles
  • adapt the basic Graph procedures (PROC GPLOT, PROC GCHART and PROC GMAP).

Who Should Attend

Analysts, programmers, info-center support and experienced end-users. This course is suitable for both PC and mainframe users.

Prerequisites

Participants should have followed the course 'SAS Fundamentals - Part 1' or should have equivalent experience.

Duration

3 days

Fee (per attendee)

P.O.A.

Course Code

SAS2

Contents

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.

SAS ODS

The SAS ODS pannels; 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.


© RSM Technology 2018