topic Re: How to query metadata in SAS Programming

How to query metadata

deleted_user — Tue, 01 Apr 2008 18:46:49 GMT

Is there a way to query the metadata from the metadata server to enumerate users that have been set up through SAS Management Console?

Re: How to query metadata

Cynthia_sas — Tue, 01 Apr 2008 19:26:39 GMT

Hi:
Your question falls under the category of Security Administration or Platform Administration and is outside the scope of this discussion forum for SAS Macro, Data Step and SAS Language elements. The Security Administration piece of the Platform Administration documentation is a 239 page document. http://support.sas.com/documentation/configuration/bisecag.pdf

There is not a set of steps or code that can be posted to the forum. The whole Platform Administration documentation links are here:
http://support.sas.com/documentation/configuration/

For more help with this task, I recommend that you contact SAS Technical Support.

cynthia

Re: How to query metadata

deleted_user — Wed, 02 Apr 2008 10:32:02 GMT

Hi,

Step01:

Create xml query_logins.xml:

$METAREPOSITORY
Login

SAS

260

Step02: Start SAS V9
Step03: Set up OPTION for PROC METADATA

FILENAME input "C:\TEMP\XML\query_persons.xml";
FILENAME output "C:\TEMP\XML\query_persons_out.xml";

PROC METADATA REPOS = "Foundation"
SERVER = "127.0.0.1"
PORT = 8561
USERID = "SASADM"
PASSWORD = "PWD"
IN = input
OUT = output HEADER = FULL;
RUN;

STEP04: Run code
STEP05: Check query_persons_out.xml

M.

Re: How to query metadata

deleted_user — Thu, 03 Apr 2008 17:25:44 GMT

matej...

besides there being one mistake in your code ("Create xml query_logins.xml:" - should be changed to query_persons.xml), it worked just fine. It did exactly what I had asked, it brought me back an XML file with the usernames of all the people that have been manually added in the SAS management console.

With this info, I think I'll be able to write the code to do my own version of identity management. Thanks so much!