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 (April 2001)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 24 Apr 2001 16:11:41 -0400
Reply-To:     Mark Casazza <casazzam@ADELPHI.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Mark Casazza <casazzam@ADELPHI.EDU>
Subject:      Re: Value exclusion
Comments: To: David_Wilson@GALLUP.COM
Content-Type: text/plain; charset="iso-8859-1"

I'd just add, remember that when using functions like SUM, unless you specify the minimum number of valid values, you could wind up with very different totals (summing one valid value or summing four valid values). Just something to keep in mind.

Mark V. Casazza Office of Research, Assessment & Planning Adelphi University Levermore Hall, #307 Garden City, NY 11530

phone: (516) 877-3231 fax: (516) 877-3237 email:

"Those who cast the votes decide nothing. Those who count the votes decide everything." -Joseph Stalin

----- Original Message ----- From: "David Wilson" <David_Wilson@GALLUP.COM> Newsgroups: bit.listserv.spssx-l To: <SPSSX-L@LISTSERV.UGA.EDU> Sent: Tuesday, April 24, 2001 3:07 PM Subject: Re: Value exclusion

> Would: > > MISSING VALUES q14a to q14d (999). > COMPUTE q14_tot=SUM(q14a to q14d). > EXE. > > Do it for you.. > > -----Original Message----- > From: Luther Bernadel [mailto:BERNADL@WESTAT.COM] > Sent: Tuesday, April 24, 2001 2:52 PM > To: SPSSX-L@LISTSERV.UGA.EDU > Subject: Value exclusion > > > I have 4 variables (q14a, q14b, q14c, q14d). I have made a sum variable > (q14_tot) that adds q14a - q14d. In the process, I also want to exclude a > certain value (999) out of the calculation. Is there a simple way to do > this? > > Thank you. > > ******************************** > Luther Bernadel, Jr. > G9-109 > 301-330-7937 > e-mail: >

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