Date: Wed, 14 Nov 2007 21:30:16 -0500
Reply-To: Florio Arguillas <foa2@cornell.edu>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Florio Arguillas <foa2@cornell.edu>
Subject: Re: Ctables&showing categories
In-Reply-To: <BAY123-F363C9531B10C814A705E27D1810@phx.gbl>
Content-Type: text/plain; charset="us-ascii"; format=flowed
Behnaz,
You need to label the values of your 24 variables. If you don't,
you'll see Category1 and Category2 in the preview/display area and
you will be unable, in the Categories and Totals dialog box, to
select categories and move them into the exclude box.
Also, if your variables are labeled but you have a "mixed selection",
you will also be unable, in the Categories and Totals dialog box, to
select categories and move them into the exclude box.
What's a "mixed selection" of variables? Assuming all their values
are labeled:
1. Uneven number of categories among your 24 variables. Some
variables may have 3 categoreis, others 4, etc.
2. Variables have same number of categories, but different
values. Some variables may have values 1,2,3,4 while others have 1,2,3,5.
3. Variables have same number of categories, same values, but
different labels (even a single character difference in label will
make it a mixed selection)
So, to address your problem and activate the behavior of the
Categories and Totals dialog box you are looking for, all 24
variables should meet this condition:
They must all have the same categories meaning their values and value
labels must all be the same. It is okay if a variable's category
has 0 frequency, customs table will still consider it as not a mixed selection.
Florio
At 03:56 PM 11/14/2007, behnaz shirazi wrote:
>Hi Florio,
>Thank you for your e-mails.But I have problem with Custom Tables
>dialog box and I don't know why because after selecting my variables
>and going to Categoris and Totals window I can not active or select
>any variable in "Display" area.(Actualy I don't see any except
>"Categori1" and Category2" even when I select multiple var).That's
>why I followed Edward's suggestion but when I want to apply 24
>variables through codes ,it doesn't work.
>
>Thanks again
>Behnaz
>
>
>>From: Florio Arguillas <foa2@cornell.edu>
>>Reply-To: Florio Arguillas <foa2@cornell.edu>
>>To: SPSSX-L@LISTSERV.UGA.EDU
>>Subject: Re: Ctables&showing categories
>>Date: Tue, 13 Nov 2007 17:12:43 -0500
>>
>>Behnaz,
>>
>>In the Custom Tables dialog box, select all 24 variables and drag
>>them all at once in either the row or column dimension. Then follow
>>the remainder of the steps I outlined in my previous e-mail. It
>>seems like you prefer to work with codes, so instead of clicking OK
>>as the last step, choose PASTE instead.
>>
>>
>>At 03:58 PM 11/13/2007, behnaz shirazi wrote:
>>>Thank you very much Edward and ViAnn.
>>>I fixed that problem using recode to specific values.
>>>It's working fine .How about if I want to use this feature for more than 1
>>>variables.I have 24 variables which I need to show just one category and i
>>>want them all in one table.
>>>
>>>Thanks again
>>>Behnaz
>>>
>>>
>>>>From: Edward Boadi <eboadi@abhct.com>
>>>>Reply-To: Edward Boadi <eboadi@abhct.com>
>>>>To: SPSSX-L@LISTSERV.UGA.EDU
>>>>Subject: Re: Ctables&showing categories
>>>>Date: Tue, 13 Nov 2007 14:47:41 -0500
>>>>
>>>>Substitute 1 with the value you want to retain for the variable
>>>>AstrtnT6.
>>>>Thanks.
>>>>
>>>>-----Original Message-----
>>>>From: behnaz shirazi [mailto:mehr59@hotmail.com]
>>>>Sent: Tuesday, November 13, 2007 2:09 PM
>>>>To: Edward Boadi; SPSSX-L@LISTSERV.UGA.EDU
>>>>Subject: Re: Ctables&showing categories
>>>>
>>>>
>>>>Thanks Edward but I get errors :
>>>>CATEGORIES: Text 1 is the wrong type for variable AstrtnT6. This command
>>>>is not executed.
>>>>
>>>>Maybe my spss version doesn't have this feature.
>>>>
>>>>Thank you for your help
>>>>Behnaz
>>>>
>>>> >From: Edward Boadi <eboadi@abhct.com>
>>>> >Reply-To: Edward Boadi <eboadi@abhct.com>
>>>> >To: SPSSX-L@LISTSERV.UGA.EDU
>>>> >Subject: Re: Ctables&showing categories
>>>> >Date: Tue, 13 Nov 2007 12:04:13 -0500
>>>> >
>>>> >Hi Behnaz,
>>>> >
>>>> >This should work for you :
>>>> >
>>>> >
>>>> >* Custom Tables .
>>>> >CTABLES
>>>> > /VLABELS VARIABLES=Var1 Var2 DISPLAY=DEFAULT
>>>> > /TABLE Var1 [COUNT,' # ', F40.0, COLPCT.COUNT,'%', F40.1] BY Var2
>>>> > /CATEGORIES VARIABLES=Var1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES
>>>>
>>>> >POSITION=AFTER
>>>> > /CATEGORIES VARIABLES=Var2[1] TOTAL=YES POSITION=AFTER .
>>>> >
>>>> >The last line of the syntax (CATEGORIES VARIABLES=Var2[1] TOTAL=YES
>>>> >POSITION=AFTER)
>>>> >restricts the display to Var2 = 1.
>>>> >
>>>> >You may have to adjust the syntax to fit your needs.
>>>> >
>>>> >Thanks.
>>>> >Edward.
>>>> >
>>>> >-----Original Message-----
>>>> >From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf
>>>> >Of behnaz shirazi
>>>> >Sent: Tuesday, November 13, 2007 11:39 AM
>>>> >To: SPSSX-L@LISTSERV.UGA.EDU
>>>> >Subject: Ctables&showing categories
>>>> >
>>>> >
>>>> >Hello dear all,
>>>> >
>>>> >I have a variable which has several categories.I need to show
>>>> >percentage through ctables.But my problem is I don't need all
>>>> >categories I just want to show one category .I wonder if there is any
>>>> >way to do this. I already tried the ctables menu but this option was
>>>> >inactive.
>>>> >
>>>> >I appreciate let me know if you have any experince in this case.
>>>> >
>>>> >
>>>> >Thank you
>>>> >Behnaz
>>>> >
>>>> >_________________________________________________________________
>>>> >Don't just search. Find. Check out the new MSN Search!
>>>> >http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>>>> >
>>>> >=====================
>>>> >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
>>>> >
>>>> >=====================
>>>> >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
>>>>
>>>>_________________________________________________________________
>>>>Don't just search. Find. Check out the new MSN Search!
>>>>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>>>>
>>>>=====================
>>>>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
>>>
>>>_________________________________________________________________
>>>Express yourself instantly with MSN Messenger! Download today it's FREE!
>>>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>>>
>>>=====================
>>>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
>>
>>=====================
>>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
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today it's
>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
=====================
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
| 
