This would be an appropriate for an autoscript to do the pivoting.
Alternatively, if html output would suffice, you can use OMS syntax to capture the tables and specify the pivot you want in the OMS command.
Here is an example of the OMS approach. It pivots the number of cylinders and statistics dimensions into the columns of the html output.
oms select tables /if subtypes=['Crosstabulation']
/destination outfile='c:/temp/acrosstab.htm' format=html
/columns dimnames=["number of cylinders","statistics"].
CROSSTABS
/TABLES=origin BY cylinder
/CELLS=COUNT ROW
/COUNT ROUND CELL.
omsend.
Alternatively, if the column variable varies from table to table, you could write something like
oms select tables /if subtypes=['Crosstabulation']
/destination outfile='c:/temp/acrosstab.htm' format=html
/columns sequence=[call r2].
CROSSTABS
/TABLES=origin BY cylinder
/CELLS=COUNT ROW
/COUNT ROUND CELL.
omsend.
Note that the OMS pivots have no bearing on what you see in the Viewer.
HTH,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of Sam Ballard
Sent: Tuesday, September 18, 2007 6:16 PM
To:
[hidden email]
Subject: [SPSSX-L] Pivoting Trays
Dear SPSS Group:
I have a question regarding pivot tables in SPSS. I'm taking pivot tables
and altering them using pivoting trays. This involves moving one variable
(percent using crosstabs) from row to column.
My problem is I have to do this 20 times. Does anyone know how I can
automate this process?
I've tried to highlight all the pivot tables and make the change, but that
doesn't seem to work.
Any suggestions would be helpful.
Thanks,
Sam Ballard
SDCCD
[hidden email]
Locked
