Sum Between Variables

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Sum Between Variables

Darko_Giac
Hi there,

I'm looking for a way to sum values between variables.

For example, I have an "ID" column and a "cred" column. What I would like to know is whether it is possible to tell SPSS to look at "ID" and sum the values for "cred" for those duplicate cases.

So I'm looking to sum all of the "cred" values for case 1 and the same for case 2.

Thanks!
Reply | Threaded
Open this post in threaded view
|

Re: Sum Between Variables

Bruce Weaver
Administrator
If you mean you want the sum of cred for each unique value of ID, look up the AGGREGATE command.  

http://www.ibm.com/support/knowledgecenter/SSLVMB_24.0.0/spss/base/syn_aggregate_functions.html

In the GUI, click on Data > Aggregate.  


Darko_Giac wrote
Hi there,

I'm looking for a way to sum values between variables.

For example, I have an "ID" column and a "cred" column. What I would like to know is whether it is possible to tell SPSS to look at "ID" and sum the values for "cred" for those duplicate cases.

So I'm looking to sum all of the "cred" values for case 1 and the same for case 2.

Thanks!
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
Reply | Threaded
Open this post in threaded view
|

Re: Sum Between Variables

Darko_Giac
Thanks! Worked perfectly.