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;
... View more