|
hi, try this:
data have;
input patid per c trt;
cards;
001 22.2 1 1
002 22.2 1 2
003 22.2 1 1
004 22.2 1 1
005 22.2 1 2
;
run;
proc sql;
create table want as
select *, count(trt) as count from have
group by trt
order by patid;
quit;
Dani Fernandez
Barcelona
2010/1/12 Shaik Hymad <hymadsk@gmail.com>:
> Hi to all,
>
> I have data like
>
> patid per c trt
> 001 22.2 1 1
> 002 22.2 1 2
> 003 22.2 1 1
> 004 22.2 1 1
> 005 22.2 1 2
>
>
> i want count of patients treatment wise using datastep
>
> patid per c trt count
> 001 22.2 1 1 3
> 002 22.2 1 2 2
> 003 22.2 1 1 3
> 004 22.2 1 1 3
> 005 22.2 1 2 2
>
|
