topic Re: Reg: same Data in obs in SAS Health and Life Sciences

Reg: same Data in obs

deleted_user — Mon, 11 May 2009 06:36:03 GMT

Hi

data cus_mon;
input cus mon$ emi;
cards;
1 jan 20
2 jan 10
3 jan 20
1 feb 20
2 feb 20
3 feb 10
1 mar 20
2 mar 20
3 mar 20
run;

i want the no of customers paying the emi same amount in the months jan,feb and mar in this Dataset cusomer 1 is paying the same emi in all the three months like this i want the count of .No of customers paying the same amount in all the three months .

I am having 30,000 obs i sholud find this from that obs

Re: Reg: same Data in obs

sbb — Mon, 11 May 2009 15:51:00 GMT

It is not necessary to submit the same post in multiple forums.

Scott Barry
SBBWorks, Inc.

Re: Reg: same Data in obs

deleted_user — Fri, 29 May 2009 22:31:29 GMT

One way calculating by using Proc Freq;

proc sort data=cus_mon;
by cus emi;
run;

proc freq data=cus_mon noprint;
tables emi/out=test(where=(count=3));
by cus;
run;

proc sql ;
select count(*) from test;
quit;

~ Sukanya E

Re: Reg: same Data in obs

deleted_user — Mon, 15 Jun 2009 07:15:05 GMT

Thqs sukanya it worked