Dear all, Is there a way to programmatically update ONLY ONE aspect of a table (e.g. a column length) metadata (metadata server metadata; this is not about the descriptor portion of a SAS dataset)? The SELECT statement of PROC METALIB allows to update only one table, but it is still updates the whole metadata ... Many TIA Cheers Anne. |
Updating all metadata makes perfect sense. Any difference between the physical dataset and its metadata entry will cause problems. Serious problems.
Can you elaborate around the use case/scenario for this requirement?
As @Kurt_Bremser states, generally you want physical table structures match you metadata in the metadata server.
Changes are sometimes needed due to CR's and similar activities, but then you can probably do these updates manually (by a developer or administrator).
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.