topic Get metadata info of a SAS DI Studio Job (jobs & tables) in SAS Programming

Get metadata info of a SAS DI Studio Job (jobs & tables)

Billybob73 — Tue, 18 May 2021 11:28:43 GMT

Hi,

Does anyone know how you can make a listing of jobs and tables used in those jobs ?

I've come across code to list all libraries and tables, but what I would like to find out is how I can get metadata for a SAS DI Studio job along with the tables used inside that job.

Thanks !

Rgds

Re: Get metadata info of a SAS DI Studio Job (jobs & tables)

LinusH — Thu, 20 May 2021 11:27:41 GMT

This will give you a list of metadata objects:

https://documentation.sas.com/doc/en/bicdc/9.4/bisag/n1wwbahzhbhh6gn170r8ei6cklmk.htm

And this can give you relationships between objects:

https://documentation.sas.com/doc/en/bicdc/9.4/bisag/p1dcleibglhr6wn19yzvfz81yw5y.htm

Re: Get metadata info of a SAS DI Studio Job (jobs & tables)

AllanBowe — Thu, 17 Jun 2021 13:58:28 GMT

The Data Lineage feature in Data Controller uses proc metatada to get a full mapping of all source / target tables for each job, as described here.

It's free for 5 users, just get in touch via the website if you'd like to give it a whirl. It also provides lineage diagrams that link through to the job metadata (using an in-built metabrowse feature).