Date:         Thu, 31 Oct 2002 17:11:19 GMT
Reply-To:     Tim Berryhill <tim@AARTWOLF.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tim Berryhill <tim@AARTWOLF.COM>
Organization: Concentric Internet Services
Subject:      Re: tricky question

As Philip is writing to us from Genzyme, this request may be what utility
company programmers call a regulatory mandate.  Some agency has said, "we
will allow you to sell your product sooner if you..."

If so, then banning the NONOTES option should be practical, and a solution
based on scanning the log should be sufficient.  Also, a "solution" which
uses a sample run will fail due to the many ways SAS can create output
dataset names (SYMPUT and CALL EXECUTE, as well as proc sql).

More specs may be required.  For instance, if I have to sort a dataset and
then immediately use it for the last time to create a new dataset, I often
define a view named something like BYNAME or BYACCT and feed that to the
following step.  Perhaps it is a bad habit, but I might define several views
with the same name and totally different contents during a job (maybe I
delete each one after using it, maybe not).  Some agency minion may decide
each instance of BYACCT must be listed separately.

The management issues may be more significant than the technical issues.

Tim Berryhill

"Primak, Philip" <Philip.Primak@GENZYME.COM> wrote in message
news:3ADFDCDBBB0ED5118818000629A85918037C2D2C@KMAIL4...
> Dear SAS-L
>
>
> My problem is - is there a way to dynamically create list of all data sets
> either used or created in some specific SAS code. Foe instance, in that
> specific code below:
>
> data x;
>   set sashelp.class;
> run;
>
> proc sort data=x out=y;
>   by name;
> run;
>
> I want to get WORK.X, SASHELP.CLASS, and WORK.Y
>
> Advance thanks,
> Philip Primak
> Genzyme Corporation