BookmarkSubscribeRSS Feed
DrTwoLittle
Fluorite | Level 6

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.

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hello @DrTwoLittle,

 

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:

 

proc metalib;
  omr (library="[INSERT METADATA LIBRARY NAME HERE]" metarepository="Foundation");
  select("[INSERT TABLE NAME HERE]");
  update_rule=(delete);
  report;
run;

You can read:

http://bi-notes.com/2011/12/sas-enterprise-guide-update-metadata-library/

http://bi-notes.com/2012/12/admin-update-table-metadata-sas-code/ 

 

Also, since you seem to work with Visual Analytics: http://support.sas.com/documentation/onlinedoc/va/7.3/en/vaag.pdf page 15) On the SAS Visual Analytics Administrator app, in the Folders panel/tab you can Register and Update Tables

 

Edit: just checked the documentation of the SAS environment Manager. Depending on the version, it should be possible to Update metadata on the Folders part ( https://support.sas.com/documentation/cdl/en/evug/69029/PDF/default/evug.pdf page 24)

 

Hope it helps.

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 922 views
  • 2 likes
  • 2 in conversation