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 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 9 Oct 2002 15:04:54 -0700
Reply-To:     Student <psu02532@pdx.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Student <psu02532@pdx.edu>
Subject:      syntax question-- repeating calculations'
Content-Type: TEXT/PLAIN; charset=US-ASCII

I am stuck on a syntax problem, and hoped you could help. Clients (client ID) received TX (TX Amount) at varying times (some episodes had 1 month, others more than 1 month). The EP_CT below delineates the episodes, starting with the number 1 (i.e., episode 1 for client 161 consisted of new# 1, 2, and 3; episode 2 had 4 months (1 to 4); and episode 3 had 3 months). What I want is a case for each client-episode that totals the Tx_amounts from each of the months in that episode. I have attempted looping and Lag counting, but have been unsuccessful-- perhaps there is an easier way? Any help would be appreciated.

TX_ID Mo_Yr ClientID EP_CT Tx_Amount 103 11/1/1999 161 1 11 103 12/1/1999 161 2 31 103 1/1/2000 161 3 3 1220 2/1/2001 161 1 20 1220 3/1/2001 161 2 31 1220 4/1/2001 161 3 30 1220 5/1/2001 161 4 6 1220 9/1/2001 161 1 5 1220 10/1/2001 161 2 1 1220 11/1/2001 161 3 2 289 1/1/2001 164 1 0 289 2/1/2001 164 2 0 289 6/1/2001 164 1 0 289 10/1/2001 164 1 0

I want it to look something like this... Client_ID Tx_Amnt Episode 161 45 1 161 87 2 161 8 3 164 0 1 etc....


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