How to count the number of observations in a SAS table?

Question

I am very new to SAS. Now, I have a SAS data table as following: ID score ------------------- 01 1 02 3 03 4 04 2 Is there any way to save the number of observations in this table **using only PROC SORT and DATA step**? I want to hold the value in the log window, which is like "hold N=4" in the SAS log script. Sorry for my unprofessional description. Thanks in advance.

Answer 1

data raa;

input id $ score;

datalines;

01 1

02 2

03 3

04 4

;

run;

data _null_;

set raa nobs=totobs end=eof;

if eof then call symputx('N', totobs);

run;

%put hold N=&N;

Answer 2

The most straighforward way to do this:

proc sql;

select count(*)

from yourtable;

quit;

If you need to store it:

proc sql;

select count(*) into :myvarcount

from yourtable;

quit;

This create a macro variable that can be referenced, e.g.:

%put &myvarcount.;