https://communities.sas.com/t5/SAS-Programming/Extract-tables-in-metadata-and-physical-name/m-p/928477#M365296 <P>Hi ,</P><P>Could you help sharing SAS-code that extract all metadata tables and their Physical name ? we want to use it for controlling in SAS DI. Thanks in advance.</P><P>&nbsp;</P><P>regards</P><P>Ann</P> Wed, 15 May 2024 13:12:36 GMT AnnLyn 2024-05-15T13:12:36Z https://communities.sas.com/t5/SAS-Programming/Extract-tables-in-metadata-and-physical-name/m-p/928477#M365296 <P>Hi ,</P><P>Could you help sharing SAS-code that extract all metadata tables and their Physical name ? we want to use it for controlling in SAS DI. Thanks in advance.</P><P>&nbsp;</P><P>regards</P><P>Ann</P> Wed, 15 May 2024 13:12:36 GMT https://communities.sas.com/t5/SAS-Programming/Extract-tables-in-metadata-and-physical-name/m-p/928477#M365296 AnnLyn 2024-05-15T13:12:36Z https://communities.sas.com/t5/SAS-Programming/Extract-tables-in-metadata-and-physical-name/m-p/928587#M365358 <P>You could start with the SAS supplied macro&nbsp;%MDSECGO and then amend the script as you need it.</P> <P><A href="https://go.documentation.sas.com/doc/en/bicdc/9.4/bisecag/n1imi9yor986fsn1o25wd6l582ex.htm" target="_blank">https://go.documentation.sas.com/doc/en/bicdc/9.4/bisecag/n1imi9yor986fsn1o25wd6l582ex.htm</A>&nbsp;</P> <P>&nbsp;</P> <P>Your need is not that uncommon and if you search a bit you should find something that comes already close to what you need. <A href="https://communities.sas.com/t5/Administration-and-Deployment/How-to-get-a-complete-metadata-report/td-p/720557" target="_self">Here</A> for example.</P> <P>&nbsp;</P> Thu, 16 May 2024 02:59:02 GMT https://communities.sas.com/t5/SAS-Programming/Extract-tables-in-metadata-and-physical-name/m-p/928587#M365358 Patrick 2024-05-16T02:59:02Z