space
Previous Page | Next Page

ADABAS Data in SAS Programs

Printing ADABAS Data

Printing ADABAS data that is described by a view descriptor is like printing any other SAS data set, as shown in the following examples.

The following example contains the code for printing the ADABAS data that is described by the view descriptor VLIB.EMPINFO:

proc print data=vlib.empinfo;
   title "Brief Employee Information";
run;

VLIB.EMPINFO accesses data from the NATURAL DDM named EMPLOYEE. The following output shows the results for this example.

Results of Printing ADABAS Data

                           Brief Employee Information                          

                   OBS      EMPID    DEPT      LASTNAME

                     1     119012    CSR010    WOLF-PROVENZA
                     2     120591    SHP002    HAMMERSTEIN
                     3     123456              VARGAS
                     4     127845    ACC024    MEDER
                     5     129540    SHP002    CHOULAI
                     6     135673    ACC013    HEMESLY
                     7     212916    CSR010    WACHBERGER
                     8     216382    SHP013    PURINTON
                     9     234967    CSR004    SMITH
                    10     237642    SHP013    BATTERSBY
                    11     239185    ACC024    DOS REMEDIOS
                    12     254896    CSR011    TAYLOR-HUNYADI
                    13     321783    CSR011    GONZALES
                    14     328140    ACC043    MEDINA-SIDONIA
                    15     346917    SHP013    SHIEKELESLAM
                    16     356134    ACC013    DUNNETT
                    17     423286    ACC024    MIFUNE
                    18     456910    CSR010    ARDIS
                    19     456921    SHP002    KRAUSE
                    20     457232    ACC013    LOVELL
                    21     459287    SHP024    RODRIGUES
                    22     677890    CSR010    NISHIMATSU-LYNCH

When you use the PRINT procedure, you might want to use the OBS= option, which enables you to specify the last observation to be processed. This is especially useful when the view descriptor describes large amounts of data or when you just want to see an example of the output. The following example uses the OBS= option to print the first five observations described by the view descriptor VLIB.CUSORDR.

proc print data=vlib.cusordr (obs=5);
   title "First Five Observations Described 
          by VLIB.CUSORDR";
run;

VLIB.CUSORDR accesses data from the NATURAL DDM named ORDER. The following output shows the result of this example.

Results of Using the OBS= Option

               First Five Observations Described by VLIB.CUSORDR               

                             OBS    STOCKNUM    SHIPTO

                               1      9870      19876078
                               2      1279      39045213
                               3      8934      18543489
                               4      3478      29834248
                               5      2567      19783482

In addition to the OBS= option, the FIRSTOBS= option also works with view descriptors. The FIRSTOBS= option does not improve performance significantly because each observation must still be read and its position calculated. The POINT= option in the SET statement is not currently supported by the SAS/ACCESS interface to ADABAS.

For more information about the PRINT procedure, see the Base SAS Procedures Guide. For more information about the OBS= and FIRSTOBS= options, see the SAS Language Reference: Dictionary.

space
Previous Page | Next Page | Top of Page