Extract tables in metadata and physical name

[AnnLyn]

Hi ,

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.

regards

Ann

[Patrick]

You could start with the SAS supplied macro %MDSECGO and then amend the script as you need it.

https://go.documentation.sas.com/doc/en/bicdc/9.4/bisecag/n1imi9yor986fsn1o25wd6l582ex.htm 

Your need is not that uncommon and if you search a bit you should find something that comes already close to what you need. Here for example.