Meta Data Update Issue

[dhruvakumar]

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

[SASKiwi]

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? 

[dhruvakumar]

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