Re: How to highlight the diagonal of pre-post table

Posted by Jon Peck on
URL: http://spssx-discussion.165.s1.nabble.com/How-to-highlight-the-diagonal-of-pre-post-table-tp5740479p5740480.html

Easy to do with a small custom function.  Here's a usage example.

CROSSTABS

    /TABLES=workhard BY helpoth

    /CELLS=COUNT EXPECTED. 

    

    SPSSINC MODIFY TABLES subtype="'Crosstabulation'"

    SELECT=0 

    DIMENSION= COLUMNS LEVEL = -1

    PROCESS = PRECEDING 

    /STYLES  APPLYTO=DATACELLS 

    CUSTOMFUNCTION="diagonals.diagonals".

Sending the code separately.  Save it where Python can find it.

This makes the diagonals yellow, but it would be easy to choose different highlighting for the background

or the text.  It allows for multiple rows of statistics.

On Sun, Apr 25, 2021 at 8:52 AM Art Kendall <[hidden email]> wrote:

Consider a crosstab or table where the values on the row and column are the
same. For example, pre-post repeated measurement where cases were households
and the count of occupants were taken before and after a disaster like
Hurricane Katrina.






-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.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