How to "flip" SPSS output tables?

[John Poole]

Does anyone know whether SPSS has a method for transposing output
tables of descriptive statistics? I am using the FREQUENCIES or MEANS
procedures to calculate 7 or so descriptive stats on about 200
variables, like this:

N MEAN MEDIAN SD MIN MAX SKEW
variable1
variable2
variable3
.
.
.
variable200

Unfortunately, the these SPSS procedures list the stats in 7 rows, and
the variables in 200 columns -- which is not workable. I need 200 rows
of variables with 7 columns of stats (as above). Any ideas how to do
this, as a syntax command or a table formatting option, or...?

Thanks for help with this problem!

John Poole

--
*************************************************
John H. Poole, Ph.D.
Department of Psychiatry
University of California Medical Center
4150 Clement Street (116C)
San Francisco, CA 94061, USA

Phone: 650-281-8851 Fax: 415-750-6996
Email: po...@itsa.ucsf.edu; john....@med.va.gov
*************************************************

[Bruce Weaver]

On Wed, 26 Feb 2003, John Poole wrote:

> Does anyone know whether SPSS has a method for transposing output
> tables of descriptive statistics? I am using the FREQUENCIES or MEANS
> procedures to calculate 7 or so descriptive stats on about 200
> variables, like this:
>
> N MEAN MEDIAN SD MIN MAX SKEW
> variable1
> variable2
> variable3
> .
> .
> .
> variable200
>
> Unfortunately, the these SPSS procedures list the stats in 7 rows, and
> the variables in 200 columns -- which is not workable. I need 200 rows
> of variables with 7 columns of stats (as above). Any ideas how to do
> this, as a syntax command or a table formatting option, or...?
>
> Thanks for help with this problem!
>
> John Poole

Hi John,
I just tried an example using FREQUENCIES. If you send the output
to an Output window (rather than draft output), right-click on the table,
and select SPSS Pivot Table Object-->Open. Then in the pivot table,
select Pivot-->Transpose rows and columns. I wish there was a way to
accomplish the same thing via syntax, but there does not appear to be.

Cheers,
Bruce
--
Bruce Weaver
E-mail: wea...@mcmaster.ca
Homepage: http://www.angelfire.com/wv/bwhomedir/

[ViAnn Beadle]

On Wed, 26 Feb 2003 05:23:59 GMT, John Poole <Po...@itsa.UCSF.edu>
wrote:

>Does anyone know whether SPSS has a method for transposing output
>tables of descriptive statistics? I am using the FREQUENCIES or MEANS
>procedures to calculate 7 or so descriptive stats on about 200
>variables, like this:
>
> N MEAN MEDIAN SD MIN MAX SKEW
>variable1
>variable2
>variable3
> .
> .
> .
>variable200
>

couple of solutions come to mind:

1. Activate the table and pivot it.
2. Write a Sax Basic autoscript for this particular table type.
3. Use the Tables procedure to obtain the statistics. It lets you
(via) syntax specify the position of the statistics so your table
command would look something like this

tables
/obs = variable1 variable2 ...
/table (STATISTICS) BY variable1 + variable2 + ...
/statistics N MEAN MEDIAN SD ...

Warning--I haven't actually tested this syntax. Note that the Tables
procedure is not part of the Base.

ViAnn Beadle

[John Poole]

Thanks, Bruce & ViAnn -- it works fine. I never noticed that
right-clicking on objects in SPSS output brings up new options. -- John

[pratik...@gmail.com]

Thank you