topic Identifying input and output datasets in SAS Programming

Identifying input and output datasets

supp — Tue, 12 Nov 2019 13:09:07 GMT

While reviewing a collection of jobs (.sas files) recently I am wondering what is the best way to identify all the input and output datasets produced from the code.

Might there be a macro or procedure that can take the .sas file as input and determine all the in and out datasets and their library?

Re: Identifying input and output datasets

Tom — Tue, 12 Nov 2019 13:21:21 GMT

The best way is to review the log generated when the program runs. SAS even has a tool to help, PROC SCAPROC. https://documentation.sas.com/?docsetId=proc&docsetTarget=p0sf63lx4fs2m5n14qv1bn8p863v.htm&docsetVersion=9.4&locale=en

To tease it out of just the source code you might end up needing the build your own SAS compiler (or even SAS Macro Processor).

Re: Identifying input and output datasets

supp — Tue, 12 Nov 2019 15:06:34 GMT

@Tom, thanks for the tip on PROC SCAPROC. Sounds very interesting.