Leverage metadata user synchronization macros for other uses

Angela Hall
Angela Hall|June 13, 2012

Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE [...]

Post a Comment

How did you find that metadata?

Angela Hall
Angela Hall|June 12, 2012

A common question really and one that I get after posting code like yesterday’s All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has anyone got any tips on when those [...]

Post a Comment

In this case coolest swag does equal coolest tool

Angela Hall
Angela Hall|April 24, 2012

One of the biggest hits of the demo hall at SAS Global Forum was the cute Koala bear swag from MetaCoda.com. Everyone wanted to stop by the booth and pick one up for their badge. Driving people to your booth is the first step, but then you must have cool [...]

Post a Comment

What is the ReposID?

Angela Hall
Angela Hall|June 11, 2010

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” [...]

Post a Comment

Adding groups of users into metadata programmatically

Angela Hall
Angela Hall|June 8, 2010

Interested in adding a group of users into Metadata w/o Management Console? Included is an example of how to add one user: PROC METADATA SERVER=”my_sas_srv_name” PORT=8561 USERID=”sasadm@saspw” PASSWORD=”xxxxxxxx” PROTOCOL=BRIDGE in=”<AddMetadata> <Metadata> <Person Desc=’Manager of clinical studies.’ Name=’Joe E. Doe’ Title=’Manager of Clinical Studies’> </Person> </Metadata> <Reposid>A0000001.A5VLFKMC</Reposid> <NS>SAS</NS> <Flags>268435456</Flags> <Options/> </AddMetadata>”; [...]

Post a Comment

Automatic Updates of the SAS Data Libraries (and Tables) Metadata

Angela Hall
Angela Hall|October 5, 2009

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 [...]

Post a Comment

Clearing & Updating Metadata - Batch Tricks

Angela Hall
Angela Hall|December 17, 2008

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 [...]

Post a Comment

Import Tables in SMC required for VIEWS rather than PROC METALIB

Angela Hall
Angela Hall|March 11, 2008

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 [...]

Post a Comment

%OMABAKUP vs. Manually Backing up Repository Directory

Angela Hall
Angela Hall|January 21, 2008

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

Post a Comment

METALIB Update

Angela Hall
Angela Hall|August 16, 2007

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 [...]

Post a Comment