SAS Safety 9 Manual

A SERVICE OF

next previous

256 Using the CONTENTS Procedure Chapter 13

Partial output for this example is shown here.

Output 13.15 Using the DATASETS Procedure

Table Listing

The DATASETS Procedure

-----Directory-----

Libref: MYDBLIB

Engine: Oracle

Physical Name:

Schema/User: testuser

# Name Memtype

----------------------

1 BIRTHDAY DATA

2 CUST DATA

3 CUSTOMERS DATA

4 DELAY DATA

5 EMP DATA

6 EMPLOYEES DATA

7 FABORDER DATA

8 INTERNAT DATA

9 INVOICES DATA

10 INVS DATA

Using the CONTENTS Procedure

This example shows output from the CONTENTS procedure when it is run on a

DBMS table. Note that PROC CONTENTS shows all of the SAS metadata that is

derived from the DBMS table by the SAS/ACCESS interface.

libname mydblib oracle user=testuser password=testpass;

title ’Contents of the DELAY Table’;

proc contents data=mydblib.delay;

run;

Output from this example is shown here.