topic Re: Viewing properties of multiple datasets in SAS Procedures

Viewing properties of multiple datasets

emveee — Wed, 14 Jan 2015 16:47:51 GMT

I have 5 years' worth of datasets where I need to get the number of records (rows) for each dataset and put it in an Excel sheet . Is there a quick way or a script that can pull this information?

Right now, I have to do a right click on each dataset, view properties, copy and paste the information into Excel. I could write a sas script and type in all the datasets' name but that would take equally long.

Any advice?

Thanks!

Re: Viewing properties of multiple datasets

Reeza — Wed, 14 Jan 2015 17:07:13 GMT

Take a look at SASHELP.VTABLE or PROC DATASETS if all the files are in a specific library.

Assuming your datasets start with YEAR. Note the where condition comparisons are case sensitive.

proc sql;

create table row_counts as

select libname, name, nobs

from sashelp.vtable

where libname='WORK' and upcase(memname) like 'YEAR%';

quit;

Re: Viewing properties of multiple datasets

emveee — Wed, 14 Jan 2015 17:18:38 GMT

Genius! I made some minor modifications but it worked really well!

Thanks very much!!!