topic Re: SAS DI Job Metadata user manager datasets in SAS Programming

SAS DI Job Metadata user manager datasets

JJP1 — Thu, 27 Aug 2020 09:29:53 GMT

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 ?

Re: SAS DI Job Metadata user manager datasets

LeonidBatkhan — Thu, 27 Aug 2020 13:24:19 GMT

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.

Re: SAS DI Job Metadata user manager datasets

JJP1 — Fri, 28 Aug 2020 05:33:25 GMT

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 ?

Re: SAS DI Job Metadata user manager datasets

andreas_lds — Fri, 28 Aug 2020 05:35:10 GMT

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.

Re: SAS DI Job Metadata user manager datasets

JJP1 — Fri, 28 Aug 2020 06:28:43 GMT

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

Re: SAS DI Job Metadata user manager datasets

LeonidBatkhan — Fri, 28 Aug 2020 14:10:11 GMT

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.