topic Re: Explore & Summarize info about a Library Members(datasets) and their variables when both Datasets and Variables are unknown in SAS Procedures

Explore & Summarize info about a Library Members(datasets) and their variables when both Datasets and Variables are unknown

Nikos — Wed, 30 Apr 2014 23:37:00 GMT

Dear all,

I have a Library with unknown number of data sets and variables.

I would be grateful if you could provide me with, say a MACRO that loops through the LIBRARY and create summary tables with the following info.

1.--- Number of Datasets that reside in the Liibrary, their Names and the number of observations for each one of them

2.-- Number of variables, names and labels , type (char or numeric), length for EACH Variable within the various Datasets

3.-- For Character variables the different levels/categories (i.e. SEX -- Male, Female) including Missing and their respective Frequencies

4.-- For Numeric Values info similar to that generated by a PROC UNIVARIATE (i.e. Mean, Median, Std, Outliers etc.)

Thank you in advance.

Best regards

Nikos

Reeza — Wed, 30 Apr 2014 23:40:17 GMT

1&2 can be solved by querying the sashelp.vtable and sashelp.vcolumn tables.

Based on that you can easily do 3/4, by using the _numeric_ and _character_ shortcuts in proc freq and proc means.

ballardw — Thu, 01 May 2014 00:01:07 GMT

Proc datasets library=yourlibrarynamehere memtype=data details;

contents data=_all_ details order=varnum;

run;

quit;

Will get you 1 and 2. Options exist to create output datasets with the information.