Help using Base SAS procedures

counting the observations

Reply
Regular Contributor
Posts: 229

counting the observations

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
Regular Contributor
Posts: 229

Re: counting the observations

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
Super User
Posts: 5,424

Re: counting the observations

Or a bit easier:

Proc sql;
select id, count(*) as no
from dsn
group by id;
/* or where id = 1 */
quit;
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 119 views
  • 0 likes
  • 2 in conversation