Hi,
I have several DI jobs each taking in different source tables.
e.g:
1) job 1 - table 1, table 2
2) job 2 - table 1, table 3, table 4
3) job 3 - table 4, table 5
Is there anyway i can extract these information into a SAS dataset in the following format?
e.g.:
job_names source_tablesjob 1 table 1job 1 table 2job 2 table 1job 2 table 3job 2 table 4job 3 table 4job 3 table 5
DIS has a built-in report which gives you this information. If you need it as a SAS table then you'll have to query SAS metadata.
Googling I found here a discussion with such code which has been marked as solved.
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.