Date:         Wed, 14 Oct 2009 05:25:56 -0700
Reply-To:     kumar <urs.kumar22@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         kumar <urs.kumar22@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Hi I need very urgent
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi, i need very urgent

I have date like these
data A;
input id spend trans_date ddmmyy8.;
format trans_date date7.;
cards;
1 234 22/09/09
1 345 23/09/09
1 2345 25/09/09
1 233 26/09/09
2 2534 22/09/09
2 345 23/09/09
2 50 25/09/09
3 234 22/09/09
3 345 23/09/09
4 2345 25/09/09
4 233 26/09/09
;
run;

In these,if spend is reaches 2500 and morethan that  i need separte
varaible,how many trans is kit the spend >= 2500

the sample output


id spend trans(spend)
1 2924 3
1 233
2 2534 1
2 395
3 579
4 2578 2

Thanks in advance