Look at the AGGREGATE command which aggregates data within groups defined by
variables such as poolno, dateyear, and datemonth. It will calculate the sum
of variable within each group which can then be added to each record for
that group.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
jimjohn
Sent: Tuesday, January 29, 2008 1:56 PM
To:
[hidden email]
Subject: ratios of filtered groups in spss
can someone plz help me with this
i have three variables (poolno, dateyear, datemonth), and if i filter my
data set by these three variables, then each subset will have 6 records in
it. now i have an additional variable in my data set called outstanding
balance. i want to create an additional variable that when i filter by those
three variables, under each case, it gives me the ratio of the record's
outstanding balance to the total outstanding balance in the filtered group
of 6. does anyone have an idea how to go about this in spss? its a very big
database and i wouldn't be able to do select case and then compute variable
each time. could i maybe somehow use split file to do this? thx.
--
View this message in context:
http://www.nabble.com/ratios-of-filtered-groups-in-spss-tp15169201p15169201.
html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
