Hi Frans,

just with this I discovered your blog: morewithdata.net looks really great
and will give me months of reading time, great work! ๐Ÿ˜

Do you provide RSS Feed so that I do not miss out on the news?
https://www.morewithdata.net/feed/ does not do the trick in my feedreader
(Feedbro add on for firefox)


Matthias



Am Fr., 22. Dez. 2023 um 16:26 Uhr schrieb Frans Houweling <
fhouwel...@email.it>:

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

Reply via email to