counting the observations

[R_Win]

data xl;
input id sal;
cards;
1 2
2 1
1 1
2 2
1 1
run;

now i want the count of 1 in variable id. Message was edited by: Michel_SAS

[R_Win]

data dsn1;
set dsn;
by patid;
cnt+1;
if first.patid then cnt=1;
run;

proc sort data=dsn1;
by patid descending cnt;
run;

data dsn2;
set dsn1;
by patid;
retain totcnt;
if first.patid then totcnt=cnt;
output;
run;
proc print data=dsn2;
run;


or

[LinusH]

Or a bit easier:

Proc sql;
select id, count(*) as no
from dsn
group by id;
/* or where id = 1 */
quit;