topic Re: How to get owner of each dataset in a library in an output table in SAS Procedures

How to get owner of each dataset in a library in an output table

cfrey73 — Wed, 29 May 2019 12:33:22 GMT

I am looking to grab the owner of each table in a shared library and output the table and owner into a dataset so that we can use it to audit. I have looked into the proc contents procedure, which looks like it can get you the owner, but I don't see any way to get that into a table using either the out or out2 statements. Any help would be useful

proc contents data = lib._ALL_ memtype=data out=out_data; 
run;

Re: How to get owner of each dataset in a library in an output table

ChrisHemedinger — Wed, 29 May 2019 12:39:47 GMT

Using ODS TRACE, you can find the table names of the output you see in the ODS destination.

ods trace on;

LOG: 

Output Added:
-------------
Name:       Directory
Label:      Directory Information
Template:   Base.Datasets.Directory
Path:       Contents.Directory

From this, you can use ODS OUTPUT to add this table to your output data sets.

ods output directory=withowner;
proc contents data = sashelp._ALL_ memtype=data out=out_data; 
run;

The WITHOWNER table will contain what you need.

Re: How to get owner of each dataset in a library in an output table

cfrey73 — Wed, 29 May 2019 13:23:55 GMT

Thanks, it looks like this gives the owner of the directory, is there another command to get the owner/creator of each individual dataset within the directory, or even just to get a single table and I could write a loop over the directory.

Re: How to get owner of each dataset in a library in an output table

Reeza — Wed, 29 May 2019 16:28:37 GMT

Check out SASHELP.VTABLE?

Re: How to get owner of each dataset in a library in an output table

cfrey73 — Wed, 29 May 2019 16:49:06 GMT

I checked there, didn't see anything about who created the table

Re: How to get owner of each dataset in a library in an output table

ChrisHemedinger — Wed, 29 May 2019 17:29:28 GMT

I'm not sure that Owner is always the same as "who created it", but if you need the OS owner field for each table you could try this with PROC DATASETS -- using the same ODS TRACE/OUTPUT technique.

ods trace on;
ods output EngineHost=WithOwner;
proc datasets lib=sashelp;
 contents data=_ALL_;
quit;

data WithOwner;
 set WithOwner (where=(label1 in ('Filename' 'Owner Name')));
run;

Re: How to get owner of each dataset in a library in an output table

Reeza — Wed, 29 May 2019 17:39:55 GMT

What's your OS?
You can use FINFO functions but if you have XCMD enabled you can also query it from the OS commands

Re: How to get owner of each dataset in a library in an output table

cfrey73 — Wed, 29 May 2019 18:02:28 GMT

Operating inside of a virtual environment set up by CMS, which is running 7, unfortuanlty they limit our permissions to do basically anything useful, so it has to be limited to stuff I can query in SAS EG, and they have also disabled x commands so I can't go that route

Re: How to get owner of each dataset in a library in an output table

cfrey73 — Wed, 29 May 2019 18:10:51 GMT

thanks chris! your solution was exactly what I was looking for.