Help using Base SAS procedures

Viewing properties of multiple datasets

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Viewing properties of multiple datasets

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!


Accepted Solutions
Solution
‎01-14-2015 12:07 PM
Super User
Posts: 19,869

Re: Viewing properties of multiple datasets

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;

View solution in original post


All Replies
Solution
‎01-14-2015 12:07 PM
Super User
Posts: 19,869

Re: Viewing properties of multiple datasets

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;

New Contributor
Posts: 2

Re: Viewing properties of multiple datasets

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

Thanks very much!!!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 191 views
  • 0 likes
  • 2 in conversation