topic Re: Create SAS users through Base SAS Program in SAS Programming

Create SAS users through Base SAS Program

Hercules — Thu, 30 Jul 2015 14:13:25 GMT

Hello all,

I have a table with three column.

Column 1->User_Name

Column 2 -> User_Password

Column 3 -> Description

I want to make a SAS script through which users will create without SMC.

I have gone through some threads and documents which has shared and got an idea that it has to be achieved by some macros.

Example %mduextr, %mducmp, etc. But can't relate how to play with it.

Can somebody explain it to me? Has anybody done it before?

Re: Create SAS users through Base SAS Program

sbb — Thu, 30 Jul 2015 14:59:02 GMT

User_Password -- seriously? Have you discussed this idea with your security personnel?

Re: Create SAS users through Base SAS Program

Hercules — Thu, 30 Jul 2015 15:13:35 GMT

Haha.. Yes.

Can you tell me how to create users through sas code?

Re: Create SAS users through Base SAS Program

sbb — Thu, 30 Jul 2015 16:53:38 GMT

For "your system/environment/OS", what steps/tasks actually entail creating a user -- list what activities you would expect to perform/complete, such as the last step being some type of notification EMAIL to the user/recipient/direct-manager, for example?

Re: Create SAS users through Base SAS Program

Hercules — Thu, 30 Jul 2015 17:28:13 GMT

Sorry sbb, I lost you.

For your previous query. Yes it has been confirmed from the admin that this is what he wants from me as there are 10000 users needs to be created for a task, which is practically not possible manually from SMC. And on further note, that table is locked for all user and is only accessible by the DBA.

I just want to know how can I create users from Base SAS?

Can you please help?

Re: Create SAS users through Base SAS Program

sbb — Thu, 30 Jul 2015 18:31:42 GMT

From the info provided, this appears to be interest to create a large number of users in the SAS Management Console (SMC), as a batch process/task. Chapter 1 of the SAS 9.3 Management Console Guide mentions this specific point as a TIP, under the topic "About User Administration".

Re: Create SAS users through Base SAS Program

jakarman — Thu, 30 Jul 2015 19:10:26 GMT

Correct Scott, it is batch processing for enterprise environments. Think at 100+ users. As Anant is mentioning 10000 that is a fit. With that number of users have a look at

metacoda (Paul / Michelle Homes) Synchronizing SAS Platform Identities - platformadmin.com . These are built around the same macros-s. Extracting the metadata is more easy to start with, just retrieving. SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition It shows the tables that are in used and could be modified.

The tables are identified by that keys-id SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition that must be unique. This one is not commonly filled when doing manual updates with SMC. When left blank they are excluded.

As you probably are having an IAM system (central user registration) you could use those convention that are in place (unique keys person-id's)

Re: Create SAS users through Base SAS Program

Hercules — Thu, 30 Jul 2015 19:15:22 GMT

I was just reading the document which you've shared earlier in your previous thread. And I was getting close to it. Was about to ask that if I want to leave a table blank such as phone table and email table, what repercussions would it have. And then your reply came at that very moment.

II shall try this tomorrow and will get back to you.

Thanks a lot for the help Jaap, as always.

Re: Create SAS users through Base SAS Program

Hercules — Sat, 01 Aug 2015 02:52:37 GMT

Yup got it. It's done.

In those data set by using set statement of my table.

Also had to make users in Linux as well, did it by using X command inside the macro. Now it's Parameterized. :smileygrin:

Thanks Jaap

Re: Create SAS users through Base SAS Program

Kurt_Bremser — Mon, 03 Aug 2015 08:13:57 GMT

Well here we do it the other way round. Users are defined in the OS (AIX), and SAS synchronizes the metadata with the UNIX user base through a batch program.

Tables with certain additional data (like phone numbers) can always be created as dummy-tables.