Re: Sum statistic in descriptives

Posted by Bruce Weaver on Jul 20, 2017; 9:15pm
URL: http://spssx-discussion.165.s1.nabble.com/Sum-statistic-in-descriptives-tp5734557p5734560.html

Your SD for HYPERTENSIVE is what you would get if there is one observation with HYPERTENSIVE = 1, as shown below.  So it is a mystery to me why you are getting a sum = 0.  The code below shows me a sum of 1, with everything else matching your output.

NEW FILE.
DATASET CLOSE ALL.

INPUT PROGRAM.
LOOP ID = 1 to 244.
END CASE.
END LOOP.
END FILE.
END INPUT PROGRAM.
EXECUTE.
COMPUTE Hypertensive = ID EQ 1.  
COMPUTE Hypotensive = ID LE 110.

FORMATS Hypertensive Hypotensive (F1).
DESCRIPTIVES VARIABLES=Hypertensive Hypotensive
  /STATISTICS=MEAN SUM STDDEV MIN MAX.
* This duplicates Rebecca's pasted output except that
* the SUM for Hypertensive = 1, as expected.

FORMATS Hypertensive Hypotensive (F5.4).
DESCRIPTIVES VARIABLES=Hypertensive Hypotensive
  /STATISTICS=MEAN SUM STDDEV MIN MAX.
* Formatting the variables to display more decimals
* shows more decimals for the stats too, as JP suggested.
* But it is not changing the sums.


You could try the following to check for any cases where Hypertensive = a value other than 1 or 0.  Change ID to whatever your ID variable is called (if you have one).    

TEMPORARY.
SELECT IF NOT ANY(Hypertensive,0,1).
LIST ID Hypertensive.

If you don't have an ID variable, generate one via $CASENUM so that you can find the problematic case (if there is one).

COMPUTE ID = $CASENUM.

HTH.

Rebecca Burzette wrote

I am using IBM SPSS Version 21 and have run into a little problem using DESCRIPTIVES.  When I request the SUM stat, I get a 0 for SUM in a variable which I know has 1 case.  Here is the syntax I'm using:
DESC HYPERTENSIVE /STAT DEF SUM.
My variable is coded 0 or 1 for absence or presence.  The syntax works fine with other variables with the same coding, but with more than 1 case -- e.g., HYPOTENSIVE has an incidence of 110 and its SUM stat = 110.  The minimum is 0 and the maximum is 1, so I have no idea what's going on or how to fix it.

Here is the output I get...
Descriptive Statistics
                              N Minimum Maximum Sum Mean Std. Deviation
HYPERTENSIVE    244 0            1           0 .00   .064
HYPOTENSIVE    244 0            1       110 .45   .499
                               

Thanks,

Rebecca G. Burzette, Ph.D.
Assistant Scientist
Office of Curricular & Student Assessment
2259 Veterinary Medicine
Iowa State University
1800 Christensen Drive
Ames, Iowa 50011-1134

=====================
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