suppress cumulative percent in freq table

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

suppress cumulative percent in freq table

J McClure
Is there a simple way to do this?
Jan

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: suppress cumulative percent in freq table

ViAnn Beadle
The simplest and automatic way is to use the SPSSINC MODIFY TABLES module
from the Developer site.  MODIFY TABLES requires that the Python extensions
be installed but doesn't require any knowledge of python. If you have an
occasional table, activate the table and hide that category. Search the
archives for more info on MODIFY TABLES.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of J
McClure
Sent: Tuesday, September 07, 2010 3:03 PM
To: [hidden email]
Subject: suppress cumulative percent in freq table

Is there a simple way to do this?
Jan

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: suppress cumulative percent in freq table

John F Hall
In reply to this post by J McClure
Jan

No.

You have to open a pivot table by double-clicking the output and then delete
the column, or copy it to Word and then delete it.  Sometimes you have to
drag the right hand edge away as well to get the variables on a single line.
It's pain in the backside as someone just said about OLAP cubes, whatever
they are.  I've frequently asked for the FREQUENCIES command to be enhanced
by adding keywords for  count, percent, valid and cumul, à la CROSSTABS eg:

freq <varlist> /cel cou val .

. . . but no-one's listening, or else they send complex macro or Python
solutions.

John Hall
[hidden email]
http://surveyresearch.weebly.com


----- Original Message -----
From: J McClure
To: [hidden email]
Sent: Tuesday, September 07, 2010 11:02 PM
Subject: suppress cumulative percent in freq table



Is there a simple way to do this?
Jan

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: suppress cumulative percent in freq table

Jon K Peck

Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435



From: John F Hall <[hidden email]>
To: [hidden email]
Date: 09/07/2010 06:41 PM
Subject: Re: [SPSSX-L] suppress cumulative percent in freq table
Sent by: "SPSSX(r) Discussion" <[hidden email]>





Jan

No.

You have to open a pivot table by double-clicking the output and then delete
the column, or copy it to Word and then delete it.  Sometimes you have to
drag the right hand edge away as well to get the variables on a single line.
It's pain in the backside as someone just said about OLAP cubes, whatever
they are.  I've frequently asked for the FREQUENCIES command to be enhanced
by adding keywords for  count, percent, valid and cumul, à la CROSSTABS eg:

freq <varlist> /cel cou val .

. . . but no-one's listening, or else they send complex macro or Python
solutions.

>>>What's so hard about this?
CTABLES
  /TABLE x [COUNT COLPCT]
  /CATEGORIES VARIABLES=x TOTAL=YES.

or this?
FREQ x.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

Regards,
Jon Peck

freq x

John Hall
[hidden email]
http://surveyresearch.weebly.com


----- Original Message -----
From: J McClure
To: [hidden email]
Sent: Tuesday, September 07, 2010 11:02 PM
Subject: suppress cumulative percent in freq table



Is there a simple way to do this?
Jan

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


Reply | Threaded
Open this post in threaded view
|

Re: suppress cumulative percent in freq table

John F Hall
Yes, but I'm still updating my tutorials from 1992 and that means learning even more complex syntax.  Absolute beginners won't go for it, but they might once they're reasonably fluent in the basic stuff.  I still think
 
freq <varlist> /cel <content list> .
 
would be more intuitive and easier to understand.
----- Original Message -----
Sent: Wednesday, September 08, 2010 3:35 AM
Subject: Re: [SPSSX-L] suppress cumulative percent in freq table


Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435



From: John F Hall <[hidden email]>
To: [hidden email]
Date: 09/07/2010 06:41 PM
Subject: Re: [SPSSX-L] suppress cumulative percent in freq table
Sent by: "SPSSX(r) Discussion" <[hidden email]>





Jan

No.

You have to open a pivot table by double-clicking the output and then delete
the column, or copy it to Word and then delete it.  Sometimes you have to
drag the right hand edge away as well to get the variables on a single line.
It's pain in the backside as someone just said about OLAP cubes, whatever
they are.  I've frequently asked for the FREQUENCIES command to be enhanced
by adding keywords for  count, percent, valid and cumul, à la CROSSTABS eg:

freq <varlist> /cel cou val .

. . . but no-one's listening, or else they send complex macro or Python
solutions.

>>>What's so hard about this?
CTABLES
  /TABLE x [COUNT COLPCT]
  /CATEGORIES VARIABLES=x TOTAL=YES.

or this?
FREQ x.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

Regards,
Jon Peck

freq x

John Hall
[hidden email]
http://surveyresearch.weebly.com


----- Original Message -----
From: J McClure
To: [hidden email]
Sent: Tuesday, September 07, 2010 11:02 PM
Subject: suppress cumulative percent in freq table



Is there a simple way to do this?
Jan

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