BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
supp
Pyrite | Level 9

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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&docsetVer...

 

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).

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

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&docsetVer...

 

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).

supp
Pyrite | Level 9
@Tom, thanks for the tip on PROC SCAPROC. Sounds very interesting.
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 4663 views
  • 3 likes
  • 2 in conversation