Hi,
You can use the function:
select count(*) as countrec from tablename;
within your proc sql.
If the table is a SAS dataset, it has its size in the header and is accessible with the NOBS= option:
%macro get_table_size(inset,macvar);
data _null_;
set &inset NOBS=size;
call symput("&macvar",size);
stop;
run;
%mend;
This method takes O(k) time (that is constant time) and doesn't require scanning through the table, O(n), to count the records. Use it like this:
%let reccount=;
%get_table_size(sashelp.cars,reccount);
%put &=reccount;
Hi,
You can use the function:
select count(*) as countrec from tablename;
within your proc sql.
If the table is a SAS dataset, it has its size in the header and is accessible with the NOBS= option:
%macro get_table_size(inset,macvar);
data _null_;
set &inset NOBS=size;
call symput("&macvar",size);
stop;
run;
%mend;
This method takes O(k) time (that is constant time) and doesn't require scanning through the table, O(n), to count the records. Use it like this:
%let reccount=;
%get_table_size(sashelp.cars,reccount);
%put &=reccount;
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.