Complex tables help

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Complex tables help

Maguin, Eugene
Is this possible in complex tables (ctables)?

         x1        x2        x3        x4        x5
1 NO   25.0      24.0      23.0      22.0      21.0
2 no   25.0      23.0      22.0      21.0      20.0
3 yes  25.0      27.0      28.0      29.0      30.0
4 YES  25.0      26.0      27.0      28.0      29.0
9       5.2       7.3      10.4       8.3       9.8

Descriptively, it's like a combination of the two percentage columns on the
frequencies command. For valid values 1-4 the percentages are computed with
valid N as the demominator and for the sysmis/missing the percentage is
computed with the total N as the denominator.

Part of the command I can do.

Ctables table= by (x1 + x2 + x3 + x4 + x5) [colpct f5.1]/
   clabels collabels=opposite/categories x1 x2 x3 x4 x5 missing=include.


OR, is there an entirely different command that would give this to me?

Thanks, Gene Maguin

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