BookmarkSubscribeRSS Feed
nikhil_khanolkar
Calcite | Level 5

Hi,

Can we do the Metadata user management with base SAS code instead of using SAS Management console. In my project we want to edit user permissions on a real time basis.

e.g. adding/removing users in the already created groups in metadata

       creating new SAS users in metadata etc.

Any help on this would be appreciated.

Thanks,

Nikhil

6 REPLIES 6
LinusH
Tourmaline | Level 20

Editing metadata in SMC is a real time action...

So describe a bit more what you mean be real time, what is the requirement?

The most straight forward technique to update user/group metadata in the background is to use the %mdu-familly macros.

Data never sleeps
nikhil_khanolkar
Calcite | Level 5

Hi Linus,

Thanks for writing. Business scenario is below.

a) We have a user base out of which metadata permissions for few users might change on a frequent basis. This information would be retrieved and stored in a datasets multiple times in a day.

b) we need to use this information and update the user metadata multiple times in a day using batch job.

I hope this clariifies the problem statement.

Thanks,

Nikhil

jakarman
Barite | Level 11

Agree kurt missed that other one....

---->-- ja karman --<-----
jakarman
Barite | Level 11

The SMC is just one of the may interfaces doing and capable of doing updates into the metadatabase.
You can write almost anything using your own coding.

- SAS(R) 9.3 Language Interfaces to Metadata (batch steps)
- SAS(R) 9.4 Open Metadata Interface: Reference and Usage, Second Edition  

- SAS(R) 9.4 Metadata Model: Reference

---->-- ja karman --<-----

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1527 views
  • 0 likes
  • 4 in conversation