BookmarkSubscribeRSS Feed
oldschool
Calcite | Level 5

I am trying to find a way to get an automated listing of the input and output data sources for a SAS EG program - basically anything in the program that isn't part of the temporary working directory. Have not been able to find anything that doesn't involve a lot of manual work.

 

Is there an automated way to generate the source and output data sets for a program?

3 REPLIES 3
SASKiwi
PROC Star

In a word no. What you, and many other users have asked or tried, can you automate the documentation of a SAS program by interpreting the source code? Because there are so many ways data can be read or output it would be virtually impossible to do this both automatically and accurately.

 

Having said that it may be possible to use the SAS DICTIONARY tables to find what datasets have been updated or created by a program. You just wouldn't know whether they are "input" or "output".   

 

oldschool
Calcite | Level 5

Thanks, SASKiwi. I should clarify for everyone - the tables I need to document are those that are part of standard libariers, and they are all sitting in the project as objects - so I don't need to parse or inspect manually written code in programs. Because all of our datasets (regardless of which EG project) go to a single output directory, I will also be able to distinguish between ins and outs.

 

There's a plug-in I found called Report Viewer which seems to be able to read program data related to flows, it just doesn't show the data sets - only the queries. Have also noticed that the project mtc Tool shows the Data Items in the program, you just can't export it.

 

Both these utilities seem to indicate it's possible to do this, maybe someone just hasn't written the functionality yet? A tool that would otuput project metadata (flows, datasets, etc...) would be a really nice utility.

 

 

 

Reeza
Super User

If the code includes macro's that may definitely not be possible, because the inputs could change from run to run.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1042 views
  • 0 likes
  • 3 in conversation