https://communities.sas.com/t5/SAS-Programming/How-to-conduct-impact-analysis-of-a-metadata-table-using-SAS/m-p/901831#M356384 <P>I have a list of metadata tables registered in SAS Data Integration Studio within a specified library. Is there a method to write SAS code that generates a list including each table's name and the corresponding SAS DI jobs that utilize the table</P> Tue, 07 Nov 2023 00:31:58 GMT gyambqt 2023-11-07T00:31:58Z https://communities.sas.com/t5/SAS-Programming/How-to-conduct-impact-analysis-of-a-metadata-table-using-SAS/m-p/901831#M356384 <P>I have a list of metadata tables registered in SAS Data Integration Studio within a specified library. Is there a method to write SAS code that generates a list including each table's name and the corresponding SAS DI jobs that utilize the table</P> Tue, 07 Nov 2023 00:31:58 GMT https://communities.sas.com/t5/SAS-Programming/How-to-conduct-impact-analysis-of-a-metadata-table-using-SAS/m-p/901831#M356384 gyambqt 2023-11-07T00:31:58Z https://communities.sas.com/t5/SAS-Programming/How-to-conduct-impact-analysis-of-a-metadata-table-using-SAS/m-p/901832#M356385 <P>Isn't there already a pre-built job in SAS DIS that creates such reports?&nbsp;</P> <P>If you need something different then yes, it is possible to query SAS metadata via code but writing such code gets quickly involved. If the existing DIS report doesn't give you what you need then I'd recommend to spend some time for research/Googling as there is a good chance someone already shared code very close to what you need.</P> Tue, 07 Nov 2023 00:43:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-conduct-impact-analysis-of-a-metadata-table-using-SAS/m-p/901832#M356385 Patrick 2023-11-07T00:43:45Z