SAS/ACCESS Interface to CA-DATACOM/DB: Reference

Using the ACCESS Procedure to Extract CA-DATACOM/DB Data

Although you can access CA-DATACOM/DB data directly in your SAS programs, it is sometimes better to extract the CA-DATACOM/DB data and place them in a SAS data file. For example, if you are using the same CA-DATACOM/DB data in several SAS jobs, it may be less resource-intensive to access extracted data in a SAS data file than to access a CA-DATACOM/DB table repeatedly. (See Performance Considerations for other circumstances in which extracting data is the more efficient method.)

You can extract CA-DATACOM/DB data by using PROC ACCESS statement options. You can also extract data using the DATA step. (See Using CA-DATACOM/DB Data in SAS Programs for examples using the SQL procedure to extract CA-DATACOM/DB data and place them in a SAS data file.) Note that if you store view descriptors and SAS data files in the same SAS data library, you must give them unique member names.

Extracting with the PROC ACCESS Statement Options

To extract data using the PROC ACCESS statement options, submit the following SAS code:

proc access viewdesc=vlib.usacust out=mydata.usaout;
run;

VLIB.USACUST is the two-level name that specifies the libref and member name for the view descriptor you want to use for extracting data, in this case, USACUST. Note that VLIB.USACUST must already exist. MYDATA.USAOUT is the two-level name specifying the libref and member name for the output SAS data file.

Chapter Contents
Previous
Next
Top of Page