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!!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: