BookmarkSubscribeRSS Feed
Anne_A
Quartz | Level 8
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.
2 REPLIES 2
LinusH
Tourmaline | Level 20

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).

Data never sleeps

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 988 views
  • 0 likes
  • 3 in conversation