So you have an idea to implement queries or changes in the metadata via a program directly using SAS. Well, one of the first items of business is actually to grab the Repository ID number. Included below is some quick reference code on how to query that. PROC METADATA SERVER=”my_sas_srv_name” [...]

The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. “Wait, you did what??!@#?&” you ask? Here are my simple steps. This [...]

Using the proc metalib process to update specific elements would generate errors related to the base SAS Library conflicting with the Metalib referenced library. You can run a libname _all_ list; statement to review all the libraries available to the process. Also, the reference material utilized to improve the process [...]

If a SAS data view needs to be added to the SAS Metadata, utilize the Import Tables wizard in the SAS Management Console (SMC). “If you use PROC METALIB to import metadata for a SAS® view, the procedure incorrectly assigns a value of DATA to the MemberType attribute. The value [...]

Pausing and restarting the Metadata Server manually will allow you to take a full copy of the foundation file structure. However, the %OMABAKUP macro does this for you, which reduces the metadata server’s downtime. (Yes, do not run a manual pause or stop of the metadata server when executing %OMABAKUP) [...]

I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in [...]

I recently ran into an interesting problem with user group names in SAS BI metadata. I created a new user group to own (and then restrict access to) some Portal pages. When I tried to assign pages to the new group in the Portal I received a Java traceback with [...]

If your SMC or other metadata-based SAS tools seem to take a long time to load up when connecting to the metadata server you may benefit from running a reorg. The %OMABAKUP macro includes a reorg parameter which reduces the amount of fragmentation in how the datasets making up SAS [...]

So what do you do when you create metadata that cannot be currently managed via the SAS Management Console? Take for instance the Theme Deployments for the Portal. The standard is alright, but what company wanted their measures all to be printed with the ‘SAS Portal’ words on the top [...]