Accessing DBMS Data with the LIBNAME Statement Using the DATASETS Procedure 255
Output 13.14 Using the PRINT and MEANS Procedures
Number of Passengers per Flight by Date
----------------------------- FLIGHT=132 DEST=YYZ ------------------------------
DATE BOARDED
01MAR1998 115
02MAR1998 106
03MAR1998 75
04MAR1998 117
05MAR1998 157
06MAR1998 150
07MAR1998 164
--------- -------
FLIGHT 884
----------------------------- FLIGHT=219 DEST=LON ------------------------------
DATE BOARDED
01MAR1998 198
02MAR1998 147
03MAR1998 197
04MAR1998 232
05MAR1998 160
06MAR1998 163
07MAR1998 241
--------- -------
FLIGHT 1338
Maximum Number of Passengers per Flight
The MEANS Procedure
Analysis Variable : BOARDED
FLIGHT N Obs Max
132 7 164.0
219 7 241.0
Using the DATASETS Procedure
This example uses the DATASETS procedure to view a list of DBMS tables, in this
case, in an Oracle database.
Note: The MODIFY and ALTER statements in PROC DATASETS are not available
for use with librefs that refer to DBMS data.
libname mydblib oracle user=testuser password=testpass;
title ’Table Listing’;
proc datasets lib=mydblib;
contents data=_all_ nods;
run;
