topic Re: counting the observations in SAS Procedures

counting the observations

R_Win — Thu, 12 Mar 2009 06:22:42 GMT

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

Re: counting the observations

R_Win — Thu, 12 Mar 2009 09:44:14 GMT

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

Re: counting the observations

LinusH — Thu, 12 Mar 2009 11:47:55 GMT

Or a bit easier:

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