How to compare Metadata Repository Table information with Proc Contents results

DaveBirch — Mon, 10 May 2021 14:41:33 GMT

I've found that occasionally when promoting changes of Repository Table definitions from the Development to other environments (e.g. Test and Production) DI Studio makes mistakes and keep some of the old columns that been removed or renamed. If these mistakes are detected and corrected then promoted jobs can generate incorrect code that always produces errors or warnings. Using Proc Contents (or querying Dictionary tables) I can see what the actual columns in a table are, and manually correct the mistakes.

What I would like though is a way to (semi-) automatically compare the metadata table definitions with the actual structures found in the database.

Has anybody done this kind of comparison?

Re: How to compare Metadata Repository Table information with Proc Contents results

AllanBowe — Mon, 10 May 2021 17:09:57 GMT

Hi Dave - this macro may help (credit to @PaulHomes who wrote the original):

https://core.sasjs.io/mm__getlibmetadiffs_8sas.html

If you are interested in finding more issues with your SAS 9 metadata, we built a "plug and play" scanner that can find all kinds of health issues in a SAS 9 environment, as such as dangling metadata, security misconfigurations, SAS coding issues, custom code in DI Studio, missing primary keys, etc. Well over 100 different checks. Do get in touch if you'd like to give it a whirl.

topic Re: How to compare Metadata Repository Table information with Proc Contents results in SAS Data Management

How to compare Metadata Repository Table information with Proc Contents results

Re: How to compare Metadata Repository Table information with Proc Contents results