SAS DI Job Metadata user manager datasets

[JJP1]

hi all,

i need to build a SAS DI job by making use of SAS datasets that are part of user manager category in SMC application like person,email,etc datasets.

So i know that i can make use of userwritten code transformation by calling %mduextr macro.

but  would you please suggest is there any option can i see these datasets somewhere in SAS libraries please ?

for example how dictionary.columns are present in SASHELP library in a similar way any option to get the user manager SAS datasets ?

[LeonidBatkhan]

Hi JJP1,

When you call %mduextr macro you specify a library reference as its parameter, for example

%mduextr(libref=WORK);

Then all of the data sets that produced by this macro can be found in the WORK library: WORK.PERSON, WORK.LOGINS, WORK.EMAIL, etc. These data sets do not exist before you invoke this macro.

Please see my blog post SAS administrators tip: Keeping track of SAS users for code example.

Hope this helps.

[JJP1]

Thanks @LeonidBatkhan .

Is there any option that can i register these datasets that are present in work library and use in SAS DI jobs development as input please ?

[LeonidBatkhan]

Hi JJP1,

It's not possible to register data sets from WORK library since WORK library SAS session-specific. However, you can create a permanent library, say MUSERS, then run

%mduextr(libref=MUSERS);

and then you can register tables created by this macro in the metadata. The data tables in that library will update every time you run

%mduextr(libref=MUSERS);

You won't need to re-register these tables as their structure stays the same.

Hope this helps.

[andreas_lds]

How current do you expect the information to be? The server-admins could schedule a task calling mduextr daily and writing the data to permanent library. But then you won't see any of the changes that took place after the macro has been called. I don't think that it is possible to create views like those in sashelp-library that are automatically updated.

[JJP1]

yes thanks @andreas_lds . I was assuming that that there might be an option which i am not aware of.