I'm adding and modifying columns from a certain table, after running a little proc SQL in the source editor, the columns changes aren't visible when I look at the table properties, I have to update the table metadata first to see the desired changes.
Since I want to automate this process, is there anyway to update the table metadata from the physical table in source editor (macro, or something else)?
I think you misunderstood my question, I want to know if it is possible to update a table metadata by running some kind of script, without any human interaction.
Basically I am altering tables with a proc sql, I want to know if there is any kind of command or macro that I can invoke and that updates the table metadata without having to interact with each altered table,
As much as I know there is no such built-in function or macro in SAS and I also don't know about a user written macro which is "published".
Considering that table metadata contains also things like constraints and keys implementing automated metadata update functionality might be a bit more complicated than you think.
Table metadata is something which shouldn't be subject to regular change and not all SAS tables have to be registered as metadata.
I'm a regular SAS DI user and I wouldn't be pleased at all if you would automatically change "my" table metadata without having made an impact analysis.
I have table metadata where the physical path / table name contains a macro variable which is dynamically populated during job execution and then points to a context specific physical table. The relation metadata table : SAS table is one:many.
The questions for you will be:
Where are these table metadata used?
Is it necessary to have these tables registered at all?
What is the possible impact if changing the metadata definitions?
Who has to be informed?