SAS Base Exam 3.3

Search the site...

Sentry Page Protection

Proc Contents [3-3]
SAS Base Exam

_ALL_ Keyword

So far, we have learned how to print the descriptor portion of just a single data set.

What if you want to print all the data sets in the entire library?

There is a short cut for that.

Example

Data DS1;
Input Var1 Var2 Var3;
Datalines;
1 2 3
1 3 5
1 6 13
;
Run;

Data DS2;
Input Var1 Var2 Var3;
Datalines;
1 15 30
1 40 50
1 42 43
;
Run;

Data DS3;
Input Var1 Var2 Var3;
Datalines;
1 32 33
1 23 25
1 71 79
;
Run;

The WORK library now contains 3 data sets:

Now, let's run the code below:

Proc Contents Data=Work._all_;
Run;

The work._all_ tells SAS to run the CONTENTS procedure on all of the data sets in the WORK library.

This will first create 3 sets of tables:

1. The Library Directory

[Expand the window for better viewing]

2. The list of data sets and SAS files

3. The descriptor portion of each of the data sets in the library.

Please note that you are not required to add library reference when referring to the data sets in the WORK library.

The following code prints identical results as above.

Proc Contents Data=_all_;
Run;

Exercise

Run the CONTENTS procedure and prints the list of all of the data sets in the SASHelp library.

Need some help?

Fill out my online form.

Home
1 2 3 4 5 6 7
Summary | Final Test | Coding Exercises
Coding Project