LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 14 Oct 2009 06:01:45 -0700
Reply-To:     "dc353@hotmail.com" <dc353@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "dc353@hotmail.com" <dc353@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Hi I need very urgent
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Oct 14, 8:25 am, kumar <urs.kuma...@gmail.com> wrote: > 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

this should get you started. the last.id needs a little work to suppress duplicate record


Back to: Top of message | Previous page | Main SAS-L page