Custom Tables Grand Totals Only?

[Hal 9000]

Dear List,

Is there a way to get a Grand Total for rows without getting a
breakdown by all categories? This is driving me crazy. I've been
cheating by calculating a binary variable called Total, then adding it
to the bottom of my table as a seperate variable, but I can't do this
when the row variable is categorical. And, I shouldn't need to do
this.

What I get now:

                              Tall             Short
Male                         #                  #
Female                     #                  #
Male Total                 #                 #
Female Total             #                  #
Grand Total               #                  #

What I want:

                   Tall          Short
Male              #              #
Female          #              #
Total              #              #

Thanks!
-Gary

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

[Thew, Barbara]

Dear List

I am trying to help a colleague who uses SPSS 11 on his PC at home (he hasn't the will to upgrade yet) - he has a problem with trying to obtain an override licence from SPSS.   Can anyone tell me how to access his lock code as this version doesn't have a licence wizard.

Any help would be very much appreciated.

Thanks

Barbara

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

[Albert-Jan Roskam]

Hi,

I believe you have to run licrenew.exe from the spss installation dir.

Cheers!!
Albert-Jan


--- On Wed, 8/20/08, Thew, Barbara <[hidden email]> wrote:

> From: Thew, Barbara <[hidden email]>
> Subject: SPSS 11 - Lock Code
> To: [hidden email]
> Date: Wednesday, August 20, 2008, 6:11 PM
> Dear List
>
> I am trying to help a colleague who uses SPSS 11 on his PC
> at home (he hasn't the will to upgrade yet) - he has a
> problem with trying to obtain an override licence from SPSS.
>   Can anyone tell me how to access his lock code as this
> version doesn't have a licence wizard.
>
> Any help would be very much appreciated.
>
> Thanks
>
> Barbara
>
> =====================
> 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

[Peck, Jon]

 CTABLES
  /TABLE gender [C] BY tallshort [C]
  /CATEGORIES VARIABLES=gender TOTAL=YES.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hal 9000
Sent: Tuesday, August 19, 2008 1:35 PM
To: [hidden email]
Subject: [SPSSX-L] Custom Tables Grand Totals Only?

Dear List,

Is there a way to get a Grand Total for rows without getting a
breakdown by all categories? This is driving me crazy. I've been
cheating by calculating a binary variable called Total, then adding it
to the bottom of my table as a seperate variable, but I can't do this
when the row variable is categorical. And, I shouldn't need to do
this.

What I get now:

                              Tall             Short
Male                         #                  #
Female                     #                  #
Male Total                 #                 #
Female Total             #                  #
Grand Total               #                  #

What I want:

                   Tall          Short
Male              #              #
Female          #              #
Total              #              #

Thanks!
-Gary

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

[Hal 9000]

Thank you Jon for your reply. My question was how to prevent all
levels of a nested variable from being displayed in the total. I just
want a grand total.

so, my table would be:

ctables
 /table sex [C] > hair [C] by height [C]
 /categories variables = sex total = yes.

*** hair color (BR,BL) is broken out in the total, which I don't want
- Any ideas? Time to learn Python?.

Thanks,
-Gary


On Thu, Aug 21, 2008 at 12:26 PM, Peck, Jon <[hidden email]> wrote:

>  CTABLES
>  /TABLE gender [C] BY tallshort [C]
>  /CATEGORIES VARIABLES=gender TOTAL=YES.
>
> HTH,
> Jon Peck
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hal 9000
> Sent: Tuesday, August 19, 2008 1:35 PM
> To: [hidden email]
> Subject: [SPSSX-L] Custom Tables Grand Totals Only?
>
> Dear List,
>
> Is there a way to get a Grand Total for rows without getting a
> breakdown by all categories? This is driving me crazy. I've been
> cheating by calculating a binary variable called Total, then adding it
> to the bottom of my table as a seperate variable, but I can't do this
> when the row variable is categorical. And, I shouldn't need to do
> this.
>
> What I get now:
>
>                              Tall             Short
> Male                         #                  #
> Female                     #                  #
> Male Total                 #                 #
> Female Total             #                  #
> Grand Total               #                  #
>
> What I want:
>
>                   Tall          Short
> Male              #              #
> Female          #              #
> Total              #              #
>
> Thanks!
> -Gary
>
> =====================
> 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

[Peck, Jon]

Here's one way:

CTABLES
  /TABLE sex [C] > hair [C] + sex [S][COUNT] BY height [C]

Here's another.  A little trickier but produces a cleaner table.
compute Total = sex.

CTABLES
  /TABLE sex [C] > hair [C] + total[C] BY height [C]
 /CATEGORIES VARIABLES= total[1 2 HSUBTOTAL=' '].

And, BTW, if you want to make the total rows bold or have a different text color or cell background, my new extension command (SPSS Statistics 17 only) makes it easy to do this with syntax.

A preview:
After running one of the commands above, you could say,
SPSS MODIFY TABLES SUBTYPE="Custom Table" SELECT="total"
DIMENSION=ROWS LEVEL=-4
/STYLES TEXTSTYLE=BOLD.


HTH,
Jon

-----Original Message-----
From: Hal 9000 [mailto:[hidden email]]
Sent: Thursday, August 21, 2008 11:04 PM
To: Peck, Jon
Cc: [hidden email]
Subject: Re: [SPSSX-L] Custom Tables Grand Totals Only?

Thank you Jon for your reply. My question was how to prevent all
levels of a nested variable from being displayed in the total. I just
want a grand total.

so, my table would be:

ctables
 /table sex [C] > hair [C] by height [C]
 /categories variables = sex total = yes.

*** hair color (BR,BL) is broken out in the total, which I don't want
- Any ideas? Time to learn Python?.

Thanks,
-Gary


On Thu, Aug 21, 2008 at 12:26 PM, Peck, Jon <[hidden email]> wrote:

>  CTABLES
>  /TABLE gender [C] BY tallshort [C]
>  /CATEGORIES VARIABLES=gender TOTAL=YES.
>
> HTH,
> Jon Peck
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hal 9000
> Sent: Tuesday, August 19, 2008 1:35 PM
> To: [hidden email]
> Subject: [SPSSX-L] Custom Tables Grand Totals Only?
>
> Dear List,
>
> Is there a way to get a Grand Total for rows without getting a
> breakdown by all categories? This is driving me crazy. I've been
> cheating by calculating a binary variable called Total, then adding it
> to the bottom of my table as a seperate variable, but I can't do this
> when the row variable is categorical. And, I shouldn't need to do
> this.
>
> What I get now:
>
>                              Tall             Short
> Male                         #                  #
> Female                     #                  #
> Male Total                 #                 #
> Female Total             #                  #
> Grand Total               #                  #
>
> What I want:
>
>                   Tall          Short
> Male              #              #
> Female          #              #
> Total              #              #
>
> Thanks!
> -Gary
>
> =====================
> 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