TableLook

[Alex Huang]

CONTENTS DELETED

The author has deleted this message.

[Jon K Peck]

Newer versions of Statistics use a straddled Excel cell for the label when the levels are different, so the value appears at the top address rather than the bottom.  There is no way to make the value appear at the lower cell address that I know of from the SPSS side.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Alex Huang <[hidden email]>
To:        [hidden email]
Date:        07/08/2015 09:18 PM
Subject:        [SPSSX-L] TableLook
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear SPSSX-List,

To be exact, I discovered the following:

In SPSS 19, copy and paste (match destination formatting) a dummy
crosstabulation to excel looks like:

VAR1 * VAR02 Crosstabulation                                                                                    
Count                                                                                    
                                                  VAR2                                  
                                 0                 1                 2                 Total
VAR1                 0                 0                 1                 0                 1
                1                 1                 0                 1                 2
Total                                  1                 1                 1                 3

While the same table in SPSS23 looks in excel like this:

VAR1 * VAR2 Crosstabulation                                                                                    
Count                                                                                      
                                 VAR2                                                   Total
                                 0                 1                 2                
VAR1                 0                 0                 1                 0                 1
                1                 1                 0                 1                 2
Total                                  1                 1                 1                 3

I would like to do something such that the word "Total" appears in line with
0, 1, 2 but not VAR2. Would there be anything that can be done to achieve
this?

Thank you really much!

Best,
Alex









--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/TableLook-tp5730092.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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