Solved: Re: To search a table in SAS DI

Shakti_Sourav · Posted 06-17-2024 01:59 AM

Dear Team,

We have so many ETL jobs ( SAS DI ) in our project and I am not able to examine all the etl jobs to discover the source table that utilizes it

Kindly suggest, how to find the ETL Job that is using a particular source table in a quickest way ?

Thanks

Shakti Sourav Mohapatra

AllanBowe · Posted 06-17-2024 03:54 AM

This is a native feature in Data Controller for SAS, and available in the community (free) version

Go to View / Lineage / choose library / choose table / choose column (optional) and you get a full impact analysis (jobs and tables in png / svg / csv formats)

https://docs.datacontroller.io/videos/#data-lineage

https://git.datacontroller.io/dc/dc/releases

/Allan
MacroCore library for app developers
Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

View solution in original post

AllanBowe · Posted 06-17-2024 03:54 AM

This is a native feature in Data Controller for SAS, and available in the community (free) version

Go to View / Lineage / choose library / choose table / choose column (optional) and you get a full impact analysis (jobs and tables in png / svg / csv formats)

https://docs.datacontroller.io/videos/#data-lineage

https://git.datacontroller.io/dc/dc/releases

/Allan
MacroCore library for app developers
Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

To search a table in SAS DI

Re: To search a table in SAS DI

Re: To search a table in SAS DI

The 2025 SAS Hackathon has begun!