SAS Data Management

SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop, SAS Data Preparation and others
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

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

1 ACCEPTED SOLUTION

Accepted Solutions
AllanBowe
Barite | Level 11
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
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

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

1 REPLY 1
AllanBowe
Barite | Level 11
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
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 1 reply
  • 878 views
  • 0 likes
  • 2 in conversation