Hi Frans,
I shall follow your info. Thanks !
Have a good Christmas,
ftr
Le 22/12/2023 à 16:18, Frans Houweling a écrit :
Hi ft,
have a look at the /CATEGORIES subcommand.
Manual:
https://benpfaff.org/~blp/pspp-master/20231105144641/source/user-manual/pspp.html#CTABLES-Totals-and-Subtotals
.
Also this post might help:
https://www.morewithdata.net/ctables-exercises-part-i/
Good luck!
frans
On 12/22/23 12:33, ft gmail wrote:
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
