Nested Crosstabs

[Adam Troy]

Hi all,

I am looking to created nested Crosstabs in SPSS base 22 for pairwise comparisons (I do not have SPSS custom tables). I know you can add layers, but this adds values of a variable as rows down the table. Instead, I am looking to nest them within columns so you may have something like region within gender, where you can compare a female from the northeast's responses on a given outcome with a male from the southwest. Currently, if gender (or region) is added as a layer it creates separate rows for each gender so that all women are on one row and can only be compared by region against themselves, and so on for men.

Ideally, the header of the table would look as follows:

                                         Male                                           Female

                         Northeast South Midwest West       Northeast South Midwest West

Outcome 1           XX%     XX%     XX%   XX%           XX%    XX%   XX%   XX%   

Outcome 2           XX%     XX%     XX%   XX%           XX%    XX%   XX%   XX%  

Any advice would be greatly appreciated.

Thanks!

Adam Troy

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

You can do this by creating the table with the layer variable and then double clicking and using the pivot trays to move the layer variable into the rows.

Be aware, though, that this is not true nesting - it assumes that the nested items are really the same across the other variables.  True nesting would allow those identities to be different.  Here it is just a display option.


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




From:        Adam Troy <[hidden email]>
To:        [hidden email]
Date:        11/02/2015 09:02 AM
Subject:        [SPSSX-L] Nested Crosstabs
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi all,

I am looking to created nested Crosstabs in SPSS base 22 for pairwise comparisons (I do not have SPSS custom tables). I know you can add layers, but this adds values of a variable as rows down the table. Instead, I am looking to nest them within columns so you may have something like region within gender, where you can compare a female from the northeast's responses on a given outcome with a male from the southwest. Currently, if gender (or region) is added as a layer it creates separate rows for each gender so that all women are on one row and can only be compared by region against themselves, and so on for men.

Ideally, the header of the table would look as follows:

                                         Male                                           Female
                         Northeast South Midwest West       Northeast South Midwest West
Outcome 1           XX%     XX%     XX%   XX%           XX%    XX%   XX%   XX%   
Outcome 2           XX%     XX%     XX%   XX%           XX%    XX%   XX%   XX%  

Any advice would be greatly appreciated.

Thanks!

Adam Troy
===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@...(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