topic Re: Code to show properties of librarys in SAS Procedures

Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 13:22:53 GMT

I am looking for a piece of code I can run that will show me the last time my datasets in my librarys were modified.

Is this possible?

Re: Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 14:18:12 GMT

proc datasets library=yourLIB details ; run;

Re: Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 14:21:26 GMT

Is there a way to run this for multiple libraries or do I just have to do mutiple proc datasets statements?

Re: Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 14:23:56 GMT

probably simpler to maintain as multiple lines.

If you have a lot of these, what will youwant to do with the output?

Re: Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 14:25:04 GMT

keeping it as an HTML is fine. I am just trying to see if the data has been updated for the day

Re: Code to show properties of librarys

deleted_user — Tue, 01 Apr 2008 14:44:09 GMT

you might prefer the selection from the environment reporting tables updated in the last, say, 3 days. That is a little different [pre]%let over = 3 ;
%let since= %sysfunc( intnx( days, "&sysdate9"d, -3 ), date9 ) ;
proc sql ;
create table recent_updates as
select * from dictionary.tables
where libname ne 'SASHELP' and libname ne 'WORK'
and moDate > "&since:0:0"dt
order by moDate descending ;
;
quit;[/pre]
For your environment, you may want to add other libraries from which you want no information, like SASHELP and WORK
That could have produced the report direct from sql, but I feel I have more control in proc print like the following [pre]
proc print data= recent_updates ;
id libname memname;
var nobs nvar modate ;
run;[/pre]

Without the moDate filter, you can report all datasets.

PeterC