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!
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;
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;
Genius! I made some minor modifications but it worked really well!
Thanks very much!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.