topic Re: Meta Data Update Issue in New SAS User

Meta Data Update Issue

dhruvakumar — Tue, 27 Aug 2019 17:04:50 GMT

Dears,

We register the tables using proc metalib. After updating the table in SAS EG or SAS BASE .It not updating properly.

For instance , if we have 10 variables , suppose deleted two variables in SAS EG it should be 8 ,but in BASE SAS it is showing 10 .

Like that we are facing meta data issue.

Kindly help to advice how to fix this issue

Many Thanks

Regards,

Dhruva

Re: Meta Data Update Issue

SASKiwi — Tue, 27 Aug 2019 23:13:50 GMT

SAS metadata for registered tables doesn't update automatically when you change the structure of the physical SAS table. You have to update the metadata separately. Rerunning PROC METALIB should do this.

That is why I try to avoid registering tables in SAS metadata where at all possible for this very reason. It creates extra maintenance requirements I prefer not to have. Why do you think you need to register tables?

Re: Meta Data Update Issue

dhruvakumar — Wed, 28 Aug 2019 03:31:46 GMT

Dear SASKiwi,

Thanks for reply.As part of client requirement, the reports we are publishing in the MSBI So to access from sql we are registering the meta data.

Please could you help to provide any advice how to find the structured modified tables.

Is there we have any v lookup options to trace structure modified tables to mitigate the problem.

Many Thanks