Request option for MEANS

[Allan Reese (Cefas)]

I use MEANS to get handy tables of counts for sparse data.  It would be
*really appreciated* to have an option to suppress the "Totals" lines
when the margins are not of interest.  REPORT can do the same job but it
takes more programming.

Anyone else bothered?
Allan

R Allan Reese
Senior statistician, Cefas
The Nothe, Weymouth DT4 8UB

Tel: [phone] -direct
Fax: [phone]

www.cefas.co.uk



***********************************************************************************
This email and any attachments are intended for the named recipient only.  Its unauthorised use, distribution, disclosure, storage or copying is not permitted.  If you have received it in error, please destroy all copies and notify the sender.  In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent.  All emails may be subject to monitoring.
***********************************************************************************

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

[Jon K Peck]

You could set this up with CTABLES if you have that option.  Otherwise, consider this.

MEANS TABLES=accel BY cylinder
  /CELLS MEAN COUNT STDDEV.

SPSSINC MODIFY TABLES subtype="'Report'"
SELECT="Total" DIMENSION= ROWS HIDE=TRUE.

SPSSINC MODIFY TABLES is an extension command downloadable from SPSS Developer Central (www.spss.com/devcentral) and requires the Python programmability plugin and at least Version 17.


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

From:	"Allan Reese (Cefas)" <[hidden email]>
To:	[hidden email]
Date:	01/26/2010 09:37 AM
Subject:	[SPSSX-L] Request option for MEANS
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

I use MEANS to get handy tables of counts for sparse data.  It would be
*really appreciated* to have an option to suppress the "Totals" lines
when the margins are not of interest.  REPORT can do the same job but it
takes more programming.

Anyone else bothered?
Allan

R Allan Reese
Senior statistician, Cefas
The Nothe, Weymouth DT4 8UB

Tel: [phone] -direct
Fax: [phone]

www.cefas.co.uk



***********************************************************************************
This email and any attachments are intended for the named recipient only.  Its unauthorised use, distribution, disclosure, storage or copying is not permitted.  If you have received it in error, please destroy all copies and notify the sender.  In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent.  All emails may be subject to monitoring.
***********************************************************************************

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

AGGRAVATE, errr, AGGREGATE will also work, and is fast:

 

aggr out = * / break = cylinder / m = mean ( accel )   / sd = sd ( accel ) / n = nu.
save translate outfile='mydir/temp/output.xls'

  /type=xls /version=8 /replace /fieldnames

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In the face of ambiguity, refuse the temptation to guess.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--- On Tue, 1/26/10, Jon K Peck <[hidden email]> wrote:

From: Jon K Peck <[hidden email]>
Subject: Re: [SPSSX-L] Request option for MEANS
To: [hidden email]
Date: Tuesday, January 26, 2010, 5:46 PM

You could set this up with CTABLES if you have that option.  Otherwise, consider this.

MEANS TABLES=accel BY cylinder
  /CELLS MEAN COUNT STDDEV.

SPSSINC MODIFY TABLES subtype="'Report'"
SELECT="Total" DIMENSION= ROWS HIDE=TRUE.

SPSSINC MODIFY TABLES is an extension command downloadable from SPSS Developer Central (www.spss.com/devcentral) and requires the Python programmability plugin and at least Version 17.


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

From:	"Allan Reese (Cefas)" <[hidden email]>
To:	[hidden email]
Date:	01/26/2010 09:37 AM
Subject:	[SPSSX-L] Request option for MEANS
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

I use MEANS to get handy tables of counts for sparse data.  It would be
*really appreciated* to have an option to suppress the "Totals" lines
when the margins are not of interest.  REPORT can do the same job but it
takes more programming.

Anyone else bothered?
Allan

R Allan Reese
Senior statistician, Cefas
The Nothe, Weymouth DT4 8UB

Tel: [phone] -direct
Fax: [phone]

www.cefas.co.uk



***********************************************************************************
This email and any attachments are intended for the named recipient only.  Its unauthorised use, distribution, disclosure, storage or copying is not permitted.  If you have received it in error, please destroy all copies and notify the sender.  In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent.  All emails may be subject to monitoring.
***********************************************************************************

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