Viewing properties of multiple datasets

[emveee]

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!

[Reeza · Accepted solution]

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;

[emveee]

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

Thanks very much!!!