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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.