Date:         Mon, 7 Dec 2009 18:14:11 +0000
Reply-To:     Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Subject:      Re: sum as used in aggregate
In-Reply-To:  <97D6F0A82A6E894DAF44B9F575305CC90B3B2E8C@HCAMAIL03.ochca.com>
Content-Type: multipart/alternative;


Dear Matthew,

 

Do you mean a variable that contains only a single valid value? Can't you try with a small test data set what happens? It seems that sum.2 applies to within-case summation, not summation within a variable over cases. See

 

data list free /tinkywinky.

begin data

'' '' '' '' '' '' 1

end data.

comp dum=0.

agg

/out *

/bre dum

/lala=sum.2(tinkywinky).

exe.


HTH,

 

Ruben van den Berg


 



 


Date: Mon, 7 Dec 2009 09:43:39 -0800
From: MPirritano@ochca.com
Subject: sum as used in aggregate
To: SPSSX-L@LISTSERV.UGA.EDU





SPSS IBMers!
 
If I use the sum function in aggregate are all values included. In other words, if there is a category that only has one value, is that included in the sum, or do I need to use sum.1 as I would in a regular compute statement to be sure that cases with only one value are included in the sum.
 
Thanks!
Matt
 
Matthew Pirritano, Ph.D.
Research Analyst IV
Medical Services Initiative (MSI)
Orange County Health Care Agency
(714) 568-5648
                                          
_________________________________________________________________
New Windows 7: Find the right PC for you. Learn more.
http://windows.microsoft.com/shop

[text/html]