Add users into SAS Metadata - Management Console

[SAS_1001]

Hello,

I've an excel sheet, which has over 100+ users containing ID, Name.  They all need to be added into group General_EG_Grp which has EG and SAS Studio roles.  Pl. advise as to how to load all the users at once into SAS Metadata (Management Console).

Thanks

[Patrick]

---

@SAS_1001 wrote:

Hello,

I've an excel sheet, which has over 100+ users containing ID, Name.  They all need to be added into group General_EG_Grp which has EG and SAS Studio roles.  Pl. advise as to how to load all the users at once into SAS Metadata (Management Console).

Thanks

---

The SAS supplied macros for such tasks should give you a very good starting point to implement what you want.

http://support.sas.com/kb/40/628.html 

https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=n1xmiwz40j40jan1cxepbble8a9h.htm&doc... 

[SAS_1001]

The information provided is not much helpful.  Looking for full solution, who has already implemented.  For ex: I need to add the following user into SASMC from EG, which is stored in excel file named sasusers.

ID,         Name

mike20  Mike Hadley

This user should become the part of SAS EG group in MC.

Thanks !

[Patrick]

---

@SAS_1001 wrote:

The information provided is not much helpful.  Looking for full solution, who has already implemented.  For ex: I need to add the following user into SASMC from EG, which is stored in excel file named sasusers.

ID,         Name

mike20  Mike Hadley

This user should become the part of SAS EG group in MC.

Thanks !

---

SAS Management Console is a client like SAS EG. Where you need to add a user is in SAS Metadata (server side). 

SAS Management Console gives you an interface for managing users and groups but you can also use another SAS client and write code to manipulate SAS Metadata. You need to be very careful if writing to SAS Metadata as you can mess-up things badly if you get it wrong. Make sure you take Metadata backups before any write attempts.

The SAS artefacts and documentation I've pointed you to provide code which is already close to what you need so not sure why that's not helpful. Not sure why you expect someone will do all the work for you for free - but yes, if you're lucky then someone already implemented something very similar and is kind enough to share the code.

[SAS_1001]

Thanks for the response. I had to mess up with lots of macro to accomplish the task but in vain.  Someone has recommended to use proc metadata syntax with the prepared dataset in the format that sas expects.  Any idea about proc metadata to load uses from excel to SAS MC under User Manager ?

[Patrick]

---

@SAS_1001 wrote:

Thanks for the response. I had to mess up with lots of macro to accomplish the task but in vain.  Someone has recommended to use proc metadata syntax with the prepared dataset in the format that sas expects.  Any idea about proc metadata to load uses from excel to SAS MC under User Manager ?

---

Have you read the documentation?

https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=n0l2hp5m00a1z2n1b598q4pknfih.htm&doc...

You shouldn't have to modify any of the macros. You just need to write code which reads your Excel source data and loads it into the required table structure (the canonical tables) for the macros to work.

As per documentation macro %MDUIMPC can be used to create the canonical tables. You don't need to populate all the tables and columns. What's required is also fully documented.

https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=p1o31lg0trorn8n1rketxxe1jbr1.htm&doc... 

And you even get sample code. The sample code uses AD as source and you're using Excel. I believe you would just have to replace this bit in the sample (which populates the canonical tables) and things should work for you.

https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=p0z36im6qsfk3ln1advg12dn5lls.htm&doc...

[SAS_1001]

Thank you !  Will try it and go from there !