Wednesday, February 27, 2008

SAS ODS - SAS output objects - Trace on and Trace off to know the output objects

Take a look at the following to get comprehensive notes on SAS ODS.

http://www.asu.edu/sas/sasdoc/sashtml/ods/z0471334.htm

To know the names of the objects for ODS, use the following:

ods trace on;

proc related statements;

run;

ods trace off;

Executing this step gives the table names to use.

Now when the proc is run, use the following statement before the run; in the proc related statements.

ods output newFileName=tableName /* from the ods trace*/

The newFileName is in the work directory and one can manipulate this file to specifically pick output elements, arrange them any order one wants and combine with other outputs.

- SAS becomes an object oriented with this! (well close to what it can deliver now)

This is a very powerful technique.

No comments: