CTABLES: How to include Missing and valid in same row/column?

[J P]

Hello,

Using CTABLES to produce reports for variable sets that have Not Applicable as an option; it is coded as 99, missing. Under Summary Statistics Row N % produces percentages for all categories including NA (Missing). Row Valid N % produces percentages for all valid categories, excluding NA. In order to save space I would like to somehow include the percentage for NA on the same line as the other categories. Is this possible? I've created a calculated percentage but that also appears in the Row N % line.

Any advice is greatly appreciated.

Thanks in advance,

John

===================== 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 could put your statistics in the rows.  For example (using employee data.sav)

CTABLES
  /TABLE jobcat [C][COUNT COLPCT.COUNT , COLPCT.VALIDN ] BY gender [C]
  /SLABELS POSITION=ROW.


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




From:        J P <[hidden email]>
To:        [hidden email]
Date:        02/19/2015 08:42 AM
Subject:        [SPSSX-L] CTABLES: How to include Missing and valid in same row/column?
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hello,

Using CTABLES to produce reports for variable sets that have Not Applicable as an option; it is coded as 99, missing. Under Summary Statistics Row N % produces percentages for all categories including NA (Missing). Row Valid N % produces percentages for all valid categories, excluding NA. In order to save space I would like to somehow include the percentage for NA on the same line as the other categories. Is this possible? I've created a calculated percentage but that also appears in the Row N % line.

Any advice is greatly appreciated.

Thanks in advance,
John
===================== 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