BookmarkSubscribeRSS Feed
dhruvakumar
Obsidian | Level 7

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

2 REPLIES 2
SASKiwi
PROC Star

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
Obsidian | Level 7

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 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 731 views
  • 0 likes
  • 2 in conversation