ARDC - USING SAS ON THE MAINFRAME

USING SAS ON THE MAINFRAME

VERSION 6.09

This handout documents using SAS version 6.09 on the MVS mainframe.

As oc October 1, 2002, the default version of SAS on the MVS mainframe, when using "// EXEC SAS", is version 8.2. You can still execute version 6.09 by using "// EXEC SAS6". The JCL examples in this handout have been changed to reflect this.

Introduction
Current Release
Related Documentation
SAS Institute Training
Related ARDC Documents and Training
SAS Utilization on MVS (BATCH)
Reading Version 5 SAS Datasets and User-Defined Libraries

Introduction

The Statistical Analysis System (SAS) is a set of computer programs used with relatively simple commands to produce a variety of statistical analyses. SAS will perform simple descriptive statistics, crosstabulations, analysis of variance, regression and factor analysis, and time series analysis, as well as user-formatted reports. This documentation gives information about using SAS at USC, including which SAS release is current, a listing of available documentation, examples of JCL needed for submitting batch SAS jobs through MVS, and procedures for running SAS programs under VM/CMS.

This documentation was produced by the Academic Research and Data Center of USC. Questions about its content, as well as questions about SAS procedures, should be directed to a SAS consultant at 777-6865.

NOTE: For information on SAS modules under USC site license for DOS, Windows, OS/2 and Macintosh operating systems, refer to the handout PCSAS.

Current Release

Version 6.09 in batch mode on MVS. The SAS/GRAPH, SAS/ETS, SAS/IML are also available. The SASPROCS documentation outlines enhancements and new procedures in SAS 6 and should also be referenced.

SAS Institute Training

SAS Institute offers training courses on numerous SAS topics throughout the year. SAS Institute also offers a variety of training packages for instructor-based, video-based, and computer-based educational programs. Persons interested in registering for SAS courses or in ordering SAS courseware products should consult the current issue of SAS COMMUNICATIONS for schedules, descriptions, costs, and registration/ordering blanks. Information is also available from the SAS Institute Training page:

SAS Utilization on MVS (BATCH)

Following is the basic Job Control Language (JCL) needed for running SAS Version 6.09 in regular batch mode on the USC system:


          JOB statement
     // EXEC SAS6
          Optional DD statements
     //SYSIN DD *
          SAS program statements
     //

Following are examples of optional DD statements used in executing SAS batch jobs. For a more involved explanation of the DD statements listed in this document, consult the JCL documentation for an explanation of DD statements and parameters.

Following are examples of DD statements for a variety of functions:

1. Reading raw data from a disk storage data set named N123456.DATASET:


     //FILEIN DD DSN=N123456.DATASET,DISP=SHR

NOTE: The DD name (FILEIN in this example) must match the name on the SAS INFILE statement.

2. Reading raw data from the first file on a standard-label, cartridge tape with a serial number of 456789:


     //TAPEIN DD DSN=N123456.TAPEFILE,UNIT=CTAPE,
     // VOL=SER=456789,LABEL=(1,SL),DISP=SHR

NOTE: The DD name (TAPEIN in this example) must match the name on the SAS INFILE statement.

3. Outputting a SAS file called N123456.SASFILE (requiring approximately 7 tracks) to disk storage (1 track on disk storage equals 56,664 bytes):


     //OUTFILE DD DSN=N123456.SASFILE,
     // UNIT=DASD,DISP=(NEW,CATLG,DELETE),
     // SPACE=(TRK,(7),RLSE)

NOTE: No DCB information should be coded. The DD name ( OUTFILE in this example) must match the first part of the two-part name for the output file.

4. Outputting a SAS file called N123456.SASFILE as the second file on a standard-label cartridge tape with serial number 456789:


     //OUTFILE DD DSN=N123456.SASFILE,UNIT=CTAPE,
     // VOL=SER=456789,LABEL=(2,SL),DISP=(NEW,CATLG,DELETE)

See note for Example 3.

5. Reading the SAS file, N123456.SASFILE from disk storage:


     //IN DD DSN=N123456.SASFILE,DISP=SHR

NOTE: The DD name (IN in this example) must match the first part of the two-part name used to read it.

6. Reading the SAS file, N123456.SASFILE from the second file of a standard-label cartridge tape with serial number 456789.


     //INTAPE DD DSN=N123456.SASFILE,UNIT=CTAPE,
     // LABEL=(2,SL),VOL=SER=456789,DISP=OLD

See Note for Example 5.

7. Outputting raw data in card image to a disk storage data set called N123456.OUTSAS, allocating approximately 14 tracks:


     //OUTFILE DD DSN=N123456.OUTSAS,UNIT=DASD,
     // DCB=(LRECL=80,BLKSIZE=9040,RECFM=FB),
     // SPACE=(TRK,(14,1),RLSE),DISP=(NEW,CATLG,DELETE)

NOTE: The DD name (OUTFILE in this example) must match the the name on the FILE statement used to create it.

8. Outputting raw data to paper:


     //OUT DD SYSOUT=A

9. Produce ten copies of printed SAS output without getting multiple copies of the JCL and messages:


     //SASLIST DD SYSOUT=A,COPIES=10

NOTE: The SASLIST DD statement is not normally coded in the JCL because it is part of the cataloged SAS procedure. The effect, when used as in this example, is to override the DD statement in the cataloged procedure. This DD statement should follow the EXEC statement and precede the SYSIN DD * statement.

When running SAS jobs there are two aspects of space to consider: workspace and memory. Workspace is the amount of temporary disk space needed to store SAS data sets while the SAS job is running. Memory is the CPU REGION required to execute the job.

The amount or workspace a job will require depends on such factors as the size of the data set read into SAS, the number of new variables created in the job, whether the data set is sorted during the job, the number of times it is subset, etc. By default workspace is set at 12 cylinders of primary allocation and 5 cylinders of secondary allocation. If there is not enough workspace, SAS issues the following message:

ERROR:  3. DATA SET WORK.#DIRCKPT REQUIRES MORE SPACE THAN
           IS AVAILABLE WITHIN THE SAS DATA BASE, DSN=XXX.
           THE  ALLOCATION  SPECIFIED  BY   THE  //WORK DD
           STATEMENT  SPACE  PARAMETER  (OR THAT USED WHEN
           THE  DATA  SET  WAS  FIRST ALLOCATED) IS INSUF-
           FICIENT. THE DATA SET CONTAINS 1 EXTENT, AND NO
           SECONDARY ALLOCATION IS POSSIBLE.

To increase workspace, override a JCL statement in the cataloged SAS procedure by adding the following statement after the EXEC statement and before the FT12 statement, if used:


   //WORK DD SPACE=(CYL,(xx,yy))

Replace "xx" and "yy" with the primary and secondary allocations. Version 6 of SAS requires at least 4096K of REGION. If you specify less REGION on the JOB or EXEC statements of the SAS job, it will not execute.

If a job abends due to insufficient REGION, SAS issues a message indicating that more memory is needed to complete the task, and suggests an amount to use. To increase memory to the required amount, use the REGION parameter on the JOB statement to specify the required amount. For example, REGION=6000K.

Reading Version 5 SAS Datasets and User-Defined Libraries

Conversion from Verion 5 SAS datasets to Version 6 SAS datasets can be accomplished in one of three ways:
    1) using the DATA step,
    2) using PROC COPY, or
    3) using PROC V5TOV6.
Examples of each of these conversion techniques is documented below.

Example Using the DATA Step

Read a Version 5.18 SAS dataset named OLD which is a member of a SAS library and create a temporary, Version 6 SAS dataset named NEW.


     // EXEC SAS6
     //IN DD DSN=N123456.SAS5.LIBRARY,DISP=SHR
     //SYSIN DD *
     DATA NEW;  SET IN.OLD;
     //

NOTE: The ddname in the DD statement defining the SAS dataset (IN in this example) must match the first part of the two-part name of the SET statement.

Example Using PROC COPY

Convert the Version 5 datasets ONE and TWO in the SAS library N123456.SAS5.LIBRARY to a Version 6 library named N123456.SAS6.LIBRARY. This dataset requires 5 tracks of disk storage.


     // EXEC SAS6
     //INFILE  DD DSN=N123456.SAS5.LIBRARY,DISP=SHR
     //OUTFILE DD DSN=N123456.SAS6.LIBRARY,
     // UNIT=DASD,DISP=(NEW,CATLG,DELETE),
     // SPACE=(TRK,(5),RLSE)
     //SYSIN DD *
     PROC COPY IN=INFILE OUT=OUTFILE;
     SELECT ONE TWO / MEMTYPE=DATA;
     //

NOTE: The ddnames in the DD statements defining the input and output datasets (INFILE and OUTFILE in this example) must match the library references of the IN= and OUT= parameters.

Example Using PROC V5TOV6

Convert all SAS files in the Version 5 library N123456.SAS5.LIBRARY to a Version 6 library named N123456.SAS6.LIBRARY. This dataset requires 5 tracks of disk storage.


     // EXEC SAS6
     //INFILE  DD DSN=N123456.SAS5.LIBRARY,DISP=SHR
     //OUTFILE DD DSN=N123456.SAS6.LIBRARY,
     // UNIT=DASD,DISP=(NEW,CATLG,DELETE),
     // SPACE=(TRK,(5),RLSE)
     //SYSIN DD *
     PROC V5TOV6 IN=INFILE OUT=OUTFILE;
     //

NOTE: The ddnames in the DD statements defining the input and output datasets (INFILE and OUTFILE in this example) must match the library references of the IN= and OUT= parameters.

ARDC Documentation ARDC Home Page USC Home Page

*SAS is the registered trademark of SAS Institute Inc., Cary, N.C. 27511, U.S.A.

This page updated December 3, 2002 by Amy W. Yarbrough, Academic Research and Data Center.
Copyright © 2000, The Board of Trustees of the University of South Carolina.
URL http://www.sc.edu/ardc/docs/sas.htm

USING SAS ON THE MAINFRAME

This page updated December 3, 2002 by Amy W. Yarbrough, Academic Research and Data Center. Copyright © 2000, The Board of Trustees of the University of South Carolina. URL http://www.sc.edu/ardc/docs/sas.htm

This page updated December 3, 2002 by Amy W. Yarbrough, Academic Research and Data Center.
Copyright © 2000, The Board of Trustees of the University of South Carolina.
URL http://www.sc.edu/ardc/docs/sas.htm