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 (July 2006)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 10 Jul 2006 20:15:31 -0500
Reply-To:     "Beadle, ViAnn" <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Beadle, ViAnn" <>
Subject:      Re: Calculation of totals including missing data in cross tabs
Comments: To:
Content-Type: text/plain; charset="iso-8859-1"

How is a missing value represented? Do you have special codes like 9 for not asked, not answered, etc. which you then define missing values. Or are they represented by system-missing. If they are represented by values declared missing, then you need to use the /MISSING INCLUDE. IF they are represented by system missing, then you need to recode SYSMIS into a value and declare that as missing first.


From: SPSSX(r) Discussion on behalf of Daniel E. Martin, Ph.D. Sent: Mon 7/10/2006 5:32 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Calculation of totals including missing data in cross tabs


Hoping I can get help with this small problem. I have a database of survey data (with several organizational divisions) , and am running cross tabs with the following syntax:


COMPUTE filter_$=(Group = 1 & Division = 44).

VARIABLE LABEL filter_$ 'Group = 1 & Division = 43 (FILTER)'.

VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.

FORMAT filter_$ (f1.0).

FILTER BY filter_$.


The cross tabs below are breaking out the specific departments by items.


/TABLES=Department BY Informed Policies Answers Vent Team Enjoy Beliefs ConflictBeliefs Walks Applied Recommend

Contribution Expected Safe Respect Ethics Net Email Honesty Teamimp Positive Sensitive Insist Safteycom communication06

Teamwork06 Support06 OverallMclane




My problem is the item n and the totals are different. I realize this is due to non response in the specific item, but I am looking to calculate the row percentage by the actual # of surveys returned.

Thanks for your help!

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