Date: Wed, 13 Oct 2010 15:50:06 -0400
Reply-To: Art@DrKendall.org
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Art Kendall <Art@DrKendall.org>
Organization: Social Research Consultants
Subject: Re: FREQUENCIES-Question: How to display a category with no
respondants in it?
In-Reply-To: <4CB5BF08.3040501@DrKendall.org>
Content-type: text/html; charset=ISO-8859-1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
If you have not already found out which value is never endorsed by
any respondent and you need the output as formatted by FREQUENCIES
you could do the ctables approach first and then put in a dummy
case something like this in the data<br>
<tt>07 0 2 3 1 4</tt><br>
and<br>
<tt>missing values a to e (0)</tt><br>
in this example the dummy case says that there was no unendorsed
value for variable a. Nobody endorsed 2 for variable b. Nobody
endorsed 3 for variable c.<br>
Nobody endorsed 1 for variable d. Nobody endorsed 4 for variable e.<br>
<br>
<br>
<br>
Art<br>
On 10/13/2010 10:15 AM, Art Kendall wrote:
<blockquote cite="mid:4CB5BF08.3040501@DrKendall.org" type="cite"> One
way is to add a dummy case with a tiny weight.
<br>
Another is to use custom tables.
<br>
<br>
data list list/id (n2) a b c d e (5f1).
<br>
begin data
<br>
01 1 2 3 4 5
<br>
02 5 4 3 2 1
<br>
03 2 3 4 5 1
<br>
04 1 4 5 1 2
<br>
05 4 5 1 2 2
<br>
06 5 1 2 3 4
<br>
07 3 3 3 3 3
<br>
end data.
<br>
formats id (n2).
<br>
value labels a to e
<br>
1 'strongly disagree'
<br>
2 'disagree'
<br>
3 'neither'
<br>
4 'agree'
<br>
5 'strongly agree'.
<br>
compute wgt = 1.
<br>
if id eq 7 wgt = 1e-32.
<br>
weight by wgt.
<br>
frequencies vars = a to e.
<br>
select if id ne 7.
<br>
weight off.
<br>
* Custom Tables.
<br>
CTABLES
<br>
/VLABELS VARIABLES=a b c d e DISPLAY=BOTH
<br>
/TABLE a [COUNT F40.0] + b [COUNT F40.0] + c [COUNT F40.0] + d
[COUNT
<br>
F40.0] + e [COUNT F40.0]
<br>
/CLABELS ROWLABELS=OPPOSITE
<br>
/CATEGORIES VARIABLES=a b c d e ORDER=A KEY=VALUE EMPTY=INCLUDE.
<br>
* Custom Tables.
<br>
CTABLES
<br>
/VLABELS VARIABLES=a e DISPLAY=BOTH
<br>
/TABLE a [COUNT F40.0] + e [COUNT F40.0]
<br>
/CLABELS ROWLABELS=OPPOSITE
<br>
/CATEGORIES VARIABLES=a e ORDER=A KEY=VALUE EMPTY=INCLUDE.
<br>
<br>
Art Kendall
<br>
Social Research Consultants
<br>
<br>
<br>
On 10/13/2010 7:32 AM, Walter Funk wrote:
<br>
<blockquote type="cite">Hi,
<br>
<br>
I know I've read about this, but can't remember were to find it:
<br>
<br>
We have a variable with some valid answer categories/values not
having
<br>
been ticked by any respondant. For example, if the valid
categories are
<br>
1, 2, 3, 4 and 5 - we have only respondants answering 1, 2, 4
and 5.
<br>
<br>
But we want to have a Frequency-table with all valid answer
categories
<br>
being displayed, that is: also showing the value "3". How can we
force
<br>
SPSS to display all valid categories of a variable no matter
whether
<br>
respondants chose that answer or not?
<br>
<br>
Thanks for your help
<br>
Walter
<br>
<br>
=====================
<br>
To manage your subscription to SPSSX-L, send a message to
<br>
<a class="moz-txt-link-abbreviated" href="mailto:LISTSERV@LISTSERV.UGA.EDU">LISTSERV@LISTSERV.UGA.EDU</a> (not to SPSSX-L), with no body text
except the
<br>
command. To leave the list, send the command
<br>
SIGNOFF SPSSX-L
<br>
For a list of commands to manage subscriptions, send the command
<br>
INFO REFCARD
<br>
<br>
</blockquote>
<br>
=====================
<br>
To manage your subscription to SPSSX-L, send a message to
<br>
<a class="moz-txt-link-abbreviated" href="mailto:LISTSERV@LISTSERV.UGA.EDU">LISTSERV@LISTSERV.UGA.EDU</a> (not to SPSSX-L), with no body text
except the
<br>
command. To leave the list, send the command
<br>
SIGNOFF SPSSX-L
<br>
For a list of commands to manage subscriptions, send the command
<br>
INFO REFCARD
<br>
<br>
</blockquote>
</body>
</html>
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
| 
