The same syntax should work in V23 as in
V19, however in 23 you can also use the OUTPUT MODIFY built-in command
to transpose a table. For example, this would work.
OUTPUT MODIFY
/SELECT TABLES
/IF COMMANDS=["CTables(2)"]
LABELS=[EXACT("Table 1")] INSTANCES=[1]
/TABLE TRANSPOSE=YES.
You can generate this syntax by right
clicking on a table in the Viewer or from a number of the creation dialogs.
As for appearance, there may be very
slight differences as the table rendering engine was rewritten after V19.
You might want to use a tableLook to control the appearance precisely
or do this with OUTPUT MODIFY, depending on what you need to accomplish.
Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621
From:
Alex Huang <[hidden email]>
To:
[hidden email]
Date:
07/08/2015 05:13 AM
Subject:
[SPSSX-L] Transpose
Sent by:
"SPSSX(r)
Discussion" <[hidden email]>
Dear SPSSX-List,
I was using SPSSINC MODIFY TABLES command to transpose pivot tables in
SPSS 19 as follows:
SPSSINC MODIFY TABLES subtype="Statistics"
SELECT=0
PROCESS=ALL
/STYLES CUSTOMFUNCTION="customstylefunctions.transpose".
OMSEND TAG = ['textSuppress'].
Now I am using SPSS 23. How should I achieve the same?
Also, would there be any syntax that is compatible in both 19 and 23 (as
my colleagues are using 19)?
Moreover, I found the display format of tables are a bit different from
old versions. Is there any way that I can control the output of the pivot
table after execution?
Thank you very much!!
Best,
Alex
=====================
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
Locked
