DATA Step, Macro, Functions and more

Track program dataset dependencies

Accepted Solution Solved
Reply
New Contributor xio
New Contributor
Posts: 2
Accepted Solution

Track program dataset dependencies

Hi all,

 

how would you track dataset dependencies for a program? That is, given a program, is there a reliable way to tell which datasets it uses?

 

Simply grep'ing the program source code might not work as the datasets could potentially be referenced using macro variables. Grep'ing SAS log sounds like a better idea, but if a dataset is used by a proc sql, it won't show up in the log unless the proc sql is envoked with "_method" argument, plus modifying the existing codebase isn't always feasible.


Accepted Solutions
Solution
‎12-06-2017 07:06 AM
Super User
Super User
Posts: 9,427

Re: Track program dataset dependencies

Run proc scaproc before and after your code run (assuming you have 9.2 or greater) and this will give you information about inputs/outputs, macros etc:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a003199745.htm

 

View solution in original post


All Replies
Solution
‎12-06-2017 07:06 AM
Super User
Super User
Posts: 9,427

Re: Track program dataset dependencies

Run proc scaproc before and after your code run (assuming you have 9.2 or greater) and this will give you information about inputs/outputs, macros etc:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a003199745.htm

 

New Contributor xio
New Contributor
Posts: 2

Re: Track program dataset dependencies

You know what, that's perfect.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 104 views
  • 1 like
  • 2 in conversation