SPSSX Discussion

Ctables&showing categories

Classic

List

Threaded

14 messages Options

behnaz shirazi-2

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

Edward Boadi

Re: Ctables&showing categories

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:[hidden email]] On Behalf Of
behnaz shirazi
Sent: Tuesday, November 13, 2007 11:39 AM
To: [hidden email]
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
[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

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

Florio Arguillas

Re: Ctables&showing categories

In reply to this post by behnaz shirazi-2

Behnaz,

here's a point-and-click approach.

Assuming that you have already assigned your variable in either the
row or column dimension in the Custom Tables dialog box, under Define
(bottom left of the dialog box), click on "Categories and Totals...."
(If Categories and Totals is greyed out, just click on the name of
the variable in the display/preview area to toggle it on and
off.) Clicking "Categories and Totals... opens up the Categories
and Totals dialog box. Under Display, select the categories you want
to exclude then transfer them into the Exclude box. Click Apply, then OK.

HTH,

Florio

At 11:39 AM 11/13/2007, behnaz shirazi wrote:

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

behnaz shirazi-2

Re: Ctables&showing categories

In reply to this post by Edward Boadi

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 <[hidden email]>
>Reply-To: Edward Boadi <[hidden email]>
>To: [hidden email]
>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:[hidden email]] On Behalf Of
>behnaz shirazi
>Sent: Tuesday, November 13, 2007 11:39 AM
>To: [hidden email]
>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
>[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
>
>=====================
>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

ViAnn Beadle

Re: Ctables&showing categories

Edward's example assumes a variable taking on the value 1. If your variable
is a string or date this won't work. Here's what the syntax reference guide
says: String and date values must be quoted.

Error messages usually don't mean that something isn't implemented but that
the syntax has an error in it.

RTFM, especially if using commands like CTABLES ;-)
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
behnaz shirazi
Sent: Tuesday, November 13, 2007 12:09 PM
To: [hidden email]
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

_________________________________________________________________
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
[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

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

Edward Boadi

Re: Ctables&showing categories

In reply to this post by behnaz shirazi-2

Substitute 1 with the value you want to retain for the variable
AstrtnT6.
Thanks.

-----Original Message-----
From: behnaz shirazi [mailto:[hidden email]]
Sent: Tuesday, November 13, 2007 2:09 PM
To: Edward Boadi; [hidden email]
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

>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:[hidden email]] On Behalf
>Of behnaz shirazi
>Sent: Tuesday, November 13, 2007 11:39 AM
>To: [hidden email]
>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
>[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
>
>=====================
>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

behnaz shirazi-2

Re: Ctables&showing categories

In reply to this post by ViAnn Beadle

Dear Edward and ViAnn,

Thank you very much for your help .It is working fine.

Thanks a lot
Behnaz

>From: ViAnn Beadle <[hidden email]>
>Reply-To: ViAnn Beadle <[hidden email]>
>To: [hidden email]
>Subject: Re: Ctables&showing categories
>Date: Tue, 13 Nov 2007 12:34:30 -0700
>
>Edward's example assumes a variable taking on the value 1. If your variable
>is a string or date this won't work. Here's what the syntax reference guide
>says: String and date values must be quoted.
>
>Error messages usually don't mean that something isn't implemented but that
>the syntax has an error in it.
>
>RTFM, especially if using commands like CTABLES ;-)
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>behnaz shirazi
>Sent: Tuesday, November 13, 2007 12:09 PM
>To: [hidden email]
>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 <[hidden email]>
> >Reply-To: Edward Boadi <[hidden email]>
> >To: [hidden email]
> >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:[hidden email]] On Behalf Of
> >behnaz shirazi
> >Sent: Tuesday, November 13, 2007 11:39 AM
> >To: [hidden email]
> >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
> >[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
> >
> >=====================
> >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
>
>_________________________________________________________________
>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
>[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
>
>=====================
>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

_________________________________________________________________
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
[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

Keith McCormick

Re: Ctables&showing categorie

In reply to this post by behnaz shirazi-2

Hi All,

I just did an experiment to confirm this.Prfectly good syntax won't
work if you change the level of measurement in the variable view.
Anyone who uses CTables in the menus can fall prey to this, but a
mismatch can make workable syntax, unworkable.

I think that is the problem here.

Keith
www.keithmccormick.com

On 11/13/07, behnaz shirazi <[hidden email]> wrote:

> 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 <[hidden email]>
> >Reply-To: Edward Boadi <[hidden email]>
> >To: [hidden email]
> >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:[hidden email]] On Behalf Of
> >behnaz shirazi
> >Sent: Tuesday, November 13, 2007 11:39 AM
> >To: [hidden email]
> >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
> >[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
> >
> >=====================
> >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
>
> _________________________________________________________________
> 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
> [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
>

behnaz shirazi-2

Re: Ctables&showing categories

In reply to this post by Edward Boadi

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 <[hidden email]>
>Reply-To: Edward Boadi <[hidden email]>
>To: [hidden email]
>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:[hidden email]]
>Sent: Tuesday, November 13, 2007 2:09 PM
>To: Edward Boadi; [hidden email]
>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 <[hidden email]>
> >Reply-To: Edward Boadi <[hidden email]>
> >To: [hidden email]
> >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:[hidden email]] On Behalf
> >Of behnaz shirazi
> >Sent: Tuesday, November 13, 2007 11:39 AM
> >To: [hidden email]
> >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
> >[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
> >
> >=====================
> >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
>
>_________________________________________________________________
>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
>[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

Florio Arguillas

Re: Ctables&showing categories

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 <[hidden email]>
>>Reply-To: Edward Boadi <[hidden email]>
>>To: [hidden email]
>>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:[hidden email]]
>>Sent: Tuesday, November 13, 2007 2:09 PM
>>To: Edward Boadi; [hidden email]
>>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 <[hidden email]>
>> >Reply-To: Edward Boadi <[hidden email]>
>> >To: [hidden email]
>> >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:[hidden email]] On Behalf
>> >Of behnaz shirazi
>> >Sent: Tuesday, November 13, 2007 11:39 AM
>> >To: [hidden email]
>> >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
>> >[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
>> >
>> >=====================
>> >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
>>
>>_________________________________________________________________
>>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
>>[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
>
>_________________________________________________________________
>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
>[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

behnaz shirazi-2

Re: Ctables&showing categories

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 <[hidden email]>
>Reply-To: Florio Arguillas <[hidden email]>
>To: [hidden email]
>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 <[hidden email]>
>>>Reply-To: Edward Boadi <[hidden email]>
>>>To: [hidden email]
>>>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:[hidden email]]
>>>Sent: Tuesday, November 13, 2007 2:09 PM
>>>To: Edward Boadi; [hidden email]
>>>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 <[hidden email]>
>>> >Reply-To: Edward Boadi <[hidden email]>
>>> >To: [hidden email]
>>> >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:[hidden email]] On Behalf
>>> >Of behnaz shirazi
>>> >Sent: Tuesday, November 13, 2007 11:39 AM
>>> >To: [hidden email]
>>> >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
>>> >[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
>>> >
>>> >=====================
>>> >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
>>>
>>>_________________________________________________________________
>>>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
>>>[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
>>
>>_________________________________________________________________
>>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
>>[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
>
>=====================
>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

Florio Arguillas

Re: Ctables&showing categories

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 <[hidden email]>
>>Reply-To: Florio Arguillas <[hidden email]>
>>To: [hidden email]

>>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 <[hidden email]>
>>>>Reply-To: Edward Boadi <[hidden email]>
>>>>To: [hidden email]
>>>>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:[hidden email]]
>>>>Sent: Tuesday, November 13, 2007 2:09 PM
>>>>To: Edward Boadi; [hidden email]
>>>>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 <[hidden email]>
>>>> >Reply-To: Edward Boadi <[hidden email]>
>>>> >To: [hidden email]
>>>> >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:[hidden email]] On Behalf
>>>> >Of behnaz shirazi
>>>> >Sent: Tuesday, November 13, 2007 11:39 AM
>>>> >To: [hidden email]
>>>> >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
>>>> >[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
>>>> >
>>>> >=====================
>>>> >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
>>>>
>>>>_________________________________________________________________
>>>>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
>>>>[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
>>>
>>>_________________________________________________________________
>>>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
>>>[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
>>
>>=====================
>>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
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today it's
>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>

Peck, Jon

Re: Ctables&showing categories

If you want to do everything through the user interface, then you do need to have value labels to guide the dialog. But for syntax, you can specify what you want directly.

If x and y are category variables, and you want to show only the value 1, you can write something like this.

ctables /table x+y
/categories variables = x y [1].

Only the category 1 will show up for either variable.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Florio Arguillas
Sent: Wednesday, November 14, 2007 7:30 PM
To: [hidden email]
Subject: Re: [SPSSX-L] Ctables&showing categories

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:

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

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

behnaz shirazi-2

Re: Ctables&showing categories

Jon and Florio,

Your explanation was very useful.I highly appreciated your help.

Regards
Behnaz

>From: "Peck, Jon" <[hidden email]>
>Reply-To: "Peck, Jon" <[hidden email]>
>To: [hidden email]
>Subject: Re: Ctables&showing categories
>Date: Wed, 14 Nov 2007 22:15:54 -0600
>
>If you want to do everything through the user interface, then you do need
>to have value labels to guide the dialog. But for syntax, you can specify
>what you want directly.
>
>If x and y are category variables, and you want to show only the value 1,
>you can write something like this.
>
>ctables /table x+y
>/categories variables = x y [1].
>
>Only the category 1 will show up for either variable.
>
>HTH,
>Jon Peck
>
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>Florio Arguillas
>Sent: Wednesday, November 14, 2007 7:30 PM
>To: [hidden email]
>Subject: Re: [SPSSX-L] Ctables&showing categories
>
>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 <[hidden email]>
> >>Reply-To: Florio Arguillas <[hidden email]>
> >>To: [hidden email]
>
>
>
>
>
> >>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 <[hidden email]>
> >>>>Reply-To: Edward Boadi <[hidden email]>
> >>>>To: [hidden email]
> >>>>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:[hidden email]]
> >>>>Sent: Tuesday, November 13, 2007 2:09 PM
> >>>>To: Edward Boadi; [hidden email]
> >>>>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 <[hidden email]>
> >>>> >Reply-To: Edward Boadi <[hidden email]>
> >>>> >To: [hidden email]
> >>>> >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:[hidden email]] On
>Behalf
> >>>> >Of behnaz shirazi
> >>>> >Sent: Tuesday, November 13, 2007 11:39 AM
> >>>> >To: [hidden email]
> >>>> >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
> >>>> >[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
> >>>> >
> >>>> >=====================
> >>>> >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
> >>>>
> >>>>_________________________________________________________________
> >>>>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
> >>>>[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
> >>>
> >>>_________________________________________________________________
> >>>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
> >>>[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
> >>
> >>=====================
> >>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
> >
> >_________________________________________________________________
> >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
>[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
>
>=====================
>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

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

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