Modify Tables moveRowsToColumns

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

Modify Tables moveRowsToColumns

Ives, Melissa L

I attempted to move a row dimension to a column dimension in SPSS 25 using this syntax (with and without the "DIMENSON = ROWS' and using either SELECT="Statistics" or SELECT=0 ):

SPSSINC MODIFY TABLES subtype="Crosstabulation"
DIMENSION = ROWS
SELECT="Statistics" 
PROCESS=PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowsToColumns".


I have successfully used this syntax  to move the innermost row to the outermost. 

SPSSINC MODIFY TABLES subtype="'Crosstabulation'"
SELECT=0
PROCESS = PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowDimension".


What I want to do is move the innermost row ("Statistics") to the innermost column.

How do I do that with Modify Tables? 


Is there any better help? The syntax help that opens up doesn't really provide details for moving dimensions and I found nothing in the archives.


Thanks!


--------------

Melissa Ives




This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

===================== 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: Modify Tables moveRowsToColumns

Ives, Melissa L

Trial and error and some additional 'Googling' led me to what works.


SPSSINC MODIFY TABLES subtype="Crosstabulation"
SELECT=0 
PROCESS=PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowsToColumns(fromdim=0,  todim=0)".

Melissa


From: Ives, Melissa L
Sent: Friday, August 10, 2018 2:59 PM
To: SPSSX-List
Subject: Modify Tables moveRowsToColumns
 

I attempted to move a row dimension to a column dimension in SPSS 25 using this syntax (with and without the "DIMENSON = ROWS' and using either SELECT="Statistics" or SELECT=0 ):

SPSSINC MODIFY TABLES subtype="Crosstabulation"
DIMENSION = ROWS
SELECT="Statistics" 
PROCESS=PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowsToColumns".


I have successfully used this syntax  to move the innermost row to the outermost. 

SPSSINC MODIFY TABLES subtype="'Crosstabulation'"
SELECT=0
PROCESS = PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowDimension".


What I want to do is move the innermost row ("Statistics") to the innermost column.

How do I do that with Modify Tables? 


Is there any better help? The syntax help that opens up doesn't really provide details for moving dimensions and I found nothing in the archives.


Thanks!


--------------

Melissa Ives




This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

===================== 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: Modify Tables moveRowsToColumns

Jon Peck
Just what I was about to suggest :-)  Here's a tip: Dimension numbering varies in different table types, so it is hard to document here, but if you specify PRINTLABELS=TRUE on the command, MODIFY TABLES will display all the dimension numbers and labels for the selected table.

On Fri, Aug 10, 2018 at 1:19 PM Ives, Melissa L <[hidden email]> wrote:

Trial and error and some additional 'Googling' led me to what works.


SPSSINC MODIFY TABLES subtype="Crosstabulation"
SELECT=0 
PROCESS=PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowsToColumns(fromdim=0,  todim=0)".

Melissa


From: Ives, Melissa L
Sent: Friday, August 10, 2018 2:59 PM
To: SPSSX-List
Subject: Modify Tables moveRowsToColumns
 

I attempted to move a row dimension to a column dimension in SPSS 25 using this syntax (with and without the "DIMENSON = ROWS' and using either SELECT="Statistics" or SELECT=0 ):

SPSSINC MODIFY TABLES subtype="Crosstabulation"
DIMENSION = ROWS
SELECT="Statistics" 
PROCESS=PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowsToColumns".


I have successfully used this syntax  to move the innermost row to the outermost. 

SPSSINC MODIFY TABLES subtype="'Crosstabulation'"
SELECT=0
PROCESS = PRECEDING
/STYLES CUSTOMFUNCTION="customstylefunctions.moveRowDimension".


What I want to do is move the innermost row ("Statistics") to the innermost column.

How do I do that with Modify Tables? 


Is there any better help? The syntax help that opens up doesn't really provide details for moving dimensions and I found nothing in the archives.


Thanks!


--------------

Melissa Ives




This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

===================== 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
[hidden email]

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