SAS/ACCESS Interface to ADABAS Software

Printing Data

Printing ADABAS data 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 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. Results of the PRINT Procedure shows the output for this example.

Results of the PRINT Procedure

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 may 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. Results of Using the OBS= Option 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 SAS Procedures Guide. For more information about the OBS= and FIRSTOBS= options, see the SAS Language Reference: Dictionary.

Chapter Contents
Previous
Next
Top of Page