Here's an example of what I can do currently with this dataset and CTABLES.
Syntax:
CTABLES /TABLE QN105BA[c] + QN105BB[c] + QN105BC[c] + QN105BD[c]
/CLABELS ROWLABELS=OPPOSITE.
Output:
Custom Tables
╭──────────────────────────────────────────────────────────────┬───────────┬────────┬───────────┬─────────────┬──────────╮
│ │ Almost
│ Very │ Somewhat │ Somewhat │ Very │
│ │ certain
│ likely │ likely │ unlikely │ unlikely │
│
├───────────┼────────┼───────────┼─────────────┼──────────┤
│ │ Count
│ Count │ Count │ Count │ Count │
├──────────────────────────────────────────────────────────────┼───────────┼────────┼───────────┼─────────────┼──────────┤
│105b. How likely is it that drivers who have had too much to │
700│ 1502│ 2763│ 1307│ 609│
│drink to drive safely will A. Get stopped by the police? │
│ │ │ │ │
│105b. How likely is it that drivers who have had too much to │
1100│ 2819│ 2417│ 430│ 140│
│drink to drive safely will B. Have an accident? │
│ │ │ │ │
│105b. How likely is it that drivers who have had too much to │
1149│ 2037│ 2032│ 994│ 622│
│drink to drive safely will C. Be convicted for drunk driving? │
│ │ │ │ │
│105b. How likely is it that drivers who have had too much to │
1101│ 1834│ 2307│ 1095│ 549│
│drink to drive safely will D. Be arrested for drunk driving? │
│ │ │ │ │
╰──────────────────────────────────────────────────────────────┴───────────┴────────┴───────────┴─────────────┴──────────╯
So, progress!
On Sun, Jan 16, 2022 at 2:29 PM Ben Pfaff <[email protected]> wrote:
> Here is one data set that seems to suit the purpose:
>
> https://catalog.data.gov/dataset/2008-national-survey-of-drinking-and-driving-attitudes-and-behaviors
> It's not perfect because the variable names are poor (they are simply
> named for question numbers) and because a lot of the variables have a
> wrong measurement level, but I'm going to start from it.
>
> Please feel free to send me more data sets.
>
> On Sat, Jan 15, 2022 at 10:40 AM Ben Pfaff <[email protected]> wrote:
> >
> > Hi! I'm getting to the point with work on CTABLES that I need a good
> > data set for use in examples. A good data set would need to be:
> > * Publicly available and freely redistributable.
> > * Medium size (at least hundreds of cases).
> > * Have a mix of categorical and scale variables.
> > * Contain some variables suitable for multiple response sets.
> >
> > I can't use the data sets that come with SPSS because it's not clear
> > that they are freely redistributable.
> >
> > I'd appreciate advice and pointers.
> >
> > Thanks,
> >
> > Ben.
>
