DATA Step, Macro, Functions and more

How to query metadata

Reply
N/A
Posts: 0

How to query metadata

Is there a way to query the metadata from the metadata server to enumerate users that have been set up through SAS Management Console?
SAS Super FREQ
Posts: 8,866

Re: How to query metadata

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: How to query metadata

Posted in reply to deleted_user
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.
N/A
Posts: 0

Re: How to query metadata

Posted in reply to deleted_user
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!
Ask a Question
Discussion stats
  • 3 replies
  • 167 views
  • 0 likes
  • 2 in conversation