cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Shakti_Sourav
Quartz | Level 8 Shakti_Sourav
Quartz | Level 8
Go to Solution

To search a table in SAS DI

Posted 4 weeks ago (267 views)

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

0 Likes
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
AllanBowe
Barite | Level 11 AllanBowe
Barite | Level 11

Re: To search a table in SAS DI

Posted 4 weeks ago (217 views)  |   In reply to Shakti_Sourav
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

0 Likes
Reply
1 REPLY 1
AllanBowe
Barite | Level 11 AllanBowe
Barite | Level 11

Re: To search a table in SAS DI

Posted 4 weeks ago (218 views)  |   In reply to Shakti_Sourav
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
0 Likes
Reply

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Watch How to connect to databases in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 4 weeks ago
  • 268 views
  • 0 likes
  • 2 in conversation