Introduction to SAS on the Mainframe

Course:  SASMF
Duration:  4 Days
Level:  I
Course Summary

This course enables the participant to write programs using the SAS language. The participant learns how to read data into SAS from external files or databases; select, analyze, summarized and manipulate data; produce reports, charts and graphs.

This course is geared toward those who run SAS on a mainframe (z/OS). Lab exercises are done using TSO/ISPF and programs are run in batch. Many examples come from z/OS operations and technical support, and data types unique to the mainframe (e.g. packed decimal, binary, date/time stamps) are covered and compared to their equivalent COBOL types.

Labs must be done on a z/OS platform that has Base SAS software installed.

« Hide The Details
Topics Covered In This Course

Introduction

  • What is SAS
  • SAS vs. other tools
  • SAS on the mainframe vs. other environments
  • SAS programs
  • SAS datasets
  • Types of data in SAS
  • SAS variables and names
  • SAS data libraries
  • The SAS log
  • PROC CONTENTS

Getting your data into SAS

  • Reading data from flat files
  • INFILE and INPUT statements
  • List, column and formatted input
  • Input formats (INFORMATS)
  • Multiple observations per record (OUTPUT statement)
  • Holding the current input record (the trailing @)
  • Browsing SAS datasets in TSO
  • Backing up SAS datasets
  • Debugging a SAS program

Working with your data

  • Assignment statements
  • Functions
  • Character handling
  • Arithmetic
  • Date / time
  • IF statements
  • Looping: DO and END statements
  • Working with date and time values
  • RETAIN and SUM statements
  • Arrays

Sorting, printing and summarizing your data

  • Using SAS Procedures
  • PROC SORT
  • PROC PRINT
  • Output formats
  • Creating your own formats: PROC FORMAT
  • PUT and INPUT functions (table lookup)
  • Summarizing your data: PROC MEANS and PROC FREQ

Modifying and combining SAS datasets

  • SET statement
  • MERGE statement
  • OUTPUT statement
  • Using "IN=" and other SAS dataset options
  • Automatic variables

Common SAS applications

  • Collapsing data
  • "top ten" report
  • Producing a report from multiple data sources
  • Maintaining historical data
  • Using a flat file with multiple record types

Charts and graphs

  • PROC CHART
  • PROC PLOT

Using SAS to access DB2 tables

What You Can Expect

At the end of this course, delegates will be able to:

  • List advantages and disadvantages of running SAS on a mainframe
  • Describe the relationship between SAS datasets, SAS libraries and z/OS datasets.
  • List advantages and disadvantages of using SAS vs. COBOL for mainframe batch applications
  • Code moderately complex SAS programs using Base SAS software, and get them to run correctly in z/OS batch
  • Describe how he/she will be able to use SAS to improve productivity and effectiveness in his/her job
Who Should Take This Course

This course should be taken by mainframe technical support, operations or applications development personnel who have little or no previous knowledge in SAS.

Recommended Prerequisites

The student should be able to use TSO/ISPF to edit datasets and submit jobs, and should have a basic understanding of JCL and z/OS datasets. Previous programming experience using another language is helpful but not required.

Training Style

Instructor led. Approximately 2/3 of the time spent in lecture and 1/3 doing labs.

« Hide The Details
Related Courses
Code Course Title Duration Level
SASE
Introduction To SAS
3 Days
III
Details
SASIN
SAS Intermediate Workshop
3 Days
III
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com