How to read SAS DIS Jobs Metadata

asd3 — Tue, 10 Mar 2020 01:54:22 GMT

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_tables
job 1 table 1
job 1 table 2
job 2 table 1
job 2 table 3
job 2 table 4
job 3 table 4
job 3 table 5

Re: How to read SAS DIS Jobs Metadata

Patrick — Tue, 10 Mar 2020 04:24:12 GMT

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.