BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
It is not necessary to submit the same post in multiple forums.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
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
deleted_user
Not applicable
Thqs sukanya it worked

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 3 replies
  • 905 views
  • 0 likes
  • 2 in conversation