SAS Fundamentals - Part 2

Objectives
On successful completion of this course, attendees 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 lternative for 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
2 days
Course Code
SAS2
Contents
PROC Tabulate
Dimensions; Class; Layout.


PROC Report
Layout; Column; Define.


Overview of the SAS/FSP environment
Browse commands; adding, modifying, deleting data; changing column layout.


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.