have a look at the /CATEGORIES subcommand.
Hi,
I try to create a CTABLES cross tabulation with row
percentages in the cells, and with the sample size as the last
column plus a row for the total.
And I don't find the way how to create it.
My current syntax:
ctables /table tradin5 [rowpct pct3.0 ] by alter5
produces the following:
Custom Tables
╭─────────────────────────────────────┬──────────────────────────────────────────────╮
│ │ alter5 alternative
religiosity (regrouped) │
│
├────────┬─────────┬────────┬─────────┬────────┤
│ │ 1 - - │ 2 - │
3 0 │ 4 + │ 5 + + │
│
├────────┼─────────┼────────┼─────────┼────────┤
│ │ Row % │ Row % │
Row % │ Row % │ Row % │
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤
│tradin5 traditional religiosity 1 - -│ 16%│
65%│ 17%│ 3%│ 0%│
│ 2 - │ 7%│
48%│ 36%│ 8%│ 0%│
│ 3 0 │ 4%│
32%│ 46%│ 17%│ 1%│
│ 4 + │ 4%│
28%│ 45%│ 22%│ 2%│
│ 5 + +│ 8%│
37%│ 38%│ 15%│ 2%│
╰─────────────────────────────────────┴────────┴─────────┴────────┴─────────┴────────╯
Which is quite proper.
But I want to get a tabulation with something like this one:
╭─────────────────────────────────────┬──────────────────────────────────────────────╮
│ │ alter5 alternative
religiosity (regrouped) │
│
├────────┬─────────┬────────┬─────────┬────────┤
│ │ 1 - - │ 2 - │
3 0 │ 4 + │ 5 + + │total
│
├────────┼─────────┼────────┼─────────┼────────┤
│ │ Row % │ Row % │
Row % │ Row % │ Row % │ n
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤
│tradin5 traditional religiosity 1 - -│ 16%│
65%│ 17%│ 3%│ 0%│ 125
│ 2 - │ 7%│
48%│ 36%│ 8%│ 0%│ 67
│ 3 0 │ 4%│
32%│ 46%│ 17%│ 1%│ 511
│ 4 + │ 4%│
28%│ 45%│ 22%│ 2%│ 231
│ 5 + +│ 8%│
37%│ 38%│ 15%│ 2%│ 54
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤
│ total
│ 8%│ 37%│ 38%│ 15%│ 2%│ ...
╰─────────────────────────────────────┴────────┴─────────┴────────┴─────────┴────────╯
Where do I find this in the help pages ?
Thanks in advance
- ftr