Chapter Contents


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

Reviewing Columns

If you want to use CA-DATACOM/DB data described by a view descriptor in your SAS program but cannot remember the SAS column names or formats and informats, you can use the CONTENTS or DATASETS procedure to display this information.

The following example uses the DATASETS procedure to give you information on the view descriptor VLIB.CUSPHON, which is based on the CA-DATACOM/DB table CUSTOMERS.

proc datasets library=vlib memtype=view;
   contents data=cusphon;

Using the DATASETS Procedure with a View Descriptor shows the information for this example. The data described by VLIB.CUSPHON are shown in Data Described by the View Descriptor VLIB.CUSPHON.

Using the DATASETS Procedure with a View Descriptor
                                 The SAS System                                1
                               DATASETS PROCEDURE

Data Set Name: VLIB.CUSPHON                            Observations:         22
Member Type:   VIEW                                    Variables:            3
Engine:        SASIODDB                                Indexes:              0
Created:       11:19 Friday, October 12, 1990          Observation Length:   80
Last Modified: 12:03 Friday, October 12, 1990          Deleted Observations: 0
Data Set Type:                                         Compressed:           NO

                  -----Engine/Host Dependent Information-----

             -----Alphabetic List of Variables and Attributes-----

     #    Variable    Type    Len    Pos    Format    Informat    Label
     1    CUSTNUM     Char      8      0    $8.       $8.         CUSTOMER
     3    NAME        Char     60     20    $60.      $60.        NAME
     2    PHONE       Char     12      8    $12.      $12.        TELEPHONE

Note the following points about this output:

For more information on the DATASETS procedure, see the SAS Language Reference: Dictionary and the SAS Procedures Guide.

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.