SAS Companion for the OS/390 Environment

Accessing Nonstandard Files

Accessing IMS-DL/I and CA-IDMS Databases

Both the SAS/ACCESS interface to IMS-DL/I and the SAS/ACCESS interface to CA-IDMS include a DATA step interface. Extensions for certain SAS statements (such as INFILE, FILE, PUT, and INPUT) enable you to format database-specific calls in a SAS DATA step. Therefore, you can access the IMS or CA-IDMS data directly, without using SAS/ACCESS view descriptors. If your site licenses these interfaces, see SAS/ACCESS Interface to IMS-DL/I Software and SAS/ACCESS Interface to CA-IDMS Software: Reference for more information.

Note: The DATA step interface for IMS-DL/I is a "read/write" interface. The DATA step interface for CA-IDMS is "read" only. [cautionend]

Accessing ISAM Files

To read an ISAM file sequentially, include the ISAM keyword on the INFILE statement as in the following example:

data newdata;
   infile isamfile isam;
   input;
   /*  SAS statements  */
run;

Accessing VSAM Data Sets

Use the VSAM option to indicate that a fileref points to a VSAM external file.

To read a VSAM file with an INPUT statement, specify the VSAM option in an INFILE statement:
```
filename in1 'prod.payroll';
data mydata;
   infile in1 vsam;
   input ...;
   /* SAS statements */
run;
```
Note: A VSAM file can be read sequentially without your having to specify the VSAM option.

To write to an empty VSAM file with a PUT statement, specify the VSAM option in a FILE statement:

filename out 'myid.newdata' disp=old;
data current;
   file out vsam;
   put ...;
   /* SAS statements */
run;

To update a VSAM data set, include an INFILE statement and a FILE statement that point to the same fileref, and specify the VSAM type option in the DATA step:
```
filename mydata 'myid.newdata' disp=old;
data newdata;
   file mydata vsam;
   infile mydata vsam;
   /* SAS statements */
run;
```

Many VSAM-specific options are available with the INFILE and FILE statements. See VSAM Options for the FILE and INFILE Statements under OS/390 for details. For complete information about accessing VSAM data sets, see the SAS Guide to VSAM Processing.

Accessing the Volume Table of Contents (VTOC)

To access a disk's Volume Table of Contents (VTOC), specify the VTOC option in an INFILE statement. See VTOC Options for the INFILE Statement under OS/390 for more information.

Chapter Contents
Previous
Next
Top of Page