If the table or view that SAS is accessing is updated, I am having to log into the SAS server and run the Management Console to update the table's metadata. I go to the Data Library Manager, right click on the table and select Update Metadata.
I can see all the same information on the Web version in SAS Environement Manager, but there is no place (that I have found) to select Update Metadata for the table. This does seem to be a big ommission.
This is creating a headache for me, as this bottleneck any update of this type.
this is correct as far as I know. The metadata management from SAS Environment Manager is an on-development product and some functionality is missing from there. I always use the SAS Management Console, for interactive sessions, SAS Code and the batch tools to manage the metadata for the actions you would like to automate or schedule on batch.
I think in your case the headache is produced mostly by a misunderstanding on the tools. Perhaps it would be an idea to get a SAS Administration training course, to reduce your challenges.
An example: often the SAS datasets are changed by code that you control. You can automaticaly update the metadata of that dataset by running another piece of code after the data step such as:
omr (library="[INSERT METADATA LIBRARY NAME HERE]" metarepository="Foundation");
select("[INSERT TABLE NAME HERE]");