topic Re: SAS CODE to add group to management console in Administration and Deployment

SAS CODE to add group to management console

shuchidxt_gmail_com — Wed, 31 Oct 2018 18:44:08 GMT

I wanted to write a sas code to add a group in management console rather than manually adding them. How to do?

Re: SAS CODE to add group to management console

SASKiwi — Wed, 31 Oct 2018 20:47:29 GMT

This type of question pops up on a regular basis - how can I update SAS metadata using SAS code? My usual response is yes you can but if this is just a one-off change then you can do it far quicker manually and not have the danger of corrupting your metadata repository as well.

If you have a lot of spare time to understand the SAS metadata model, and to build and test some pretty complicated SAS code, plus be OK with corrupting your metadata repository while getting your code right, then here is a good place to start your journey:

https://documentation.sas.com/?docsetId=lrmeta&docsetTarget=lrmetawhatsnew94.htm&docsetVersion=9.4&locale=en

And this library article too: https://communities.sas.com/t5/SAS-Communities-Library/Examples-DATA-Step-Functions-for-Reading-Metadata/tac-p/503720

Re: SAS CODE to add group to management console

PaulHomes — Thu, 01 Nov 2018 01:36:12 GMT

In addition to the advice from @SASKiwi, if this is an ongoing requirement, you could also look at using the User Import Macros. Whilst those macros are usually used for syncing with AD/LDAP they can also be used to sync from any other source where you can get the information into SAS tables. It is possible you may find them easier to use and maintain that using the lower level SAS Open Metadata Interface feature.

Re: SAS CODE to add group to management console

Kurt_Bremser — Fri, 02 Nov 2018 09:15:08 GMT

Look at how user/group metadata is synced in the programs

/sashome/SASFoundation/9.4/samples/base/importpw.sas
/sashome/SASFoundation/9.4/samples/base/importad.sas

I use a slightly adapted version of the first for syncing my UNIX userbase with SAS metadata.

(/sashome is wherever you installed your SAS system)