Custom Tables
Analyze → Tables. When the fixed-shape tables from the other procedures are not the layout you want, these two build a table to your specification.
Custom Tables
When to use it. To pivot one or more categorical variables against others, with a cell statistic of your choosing — a generalisation of a crosstab and of a means-by-factor breakdown in one tool.
Dialog.
- Rows and (nested) Rows — the categorical variables down the side.
- Columns and (nested) Columns — the categorical variables across the top.
- Statistics — what each cell shows. Choose any of: Count, Valid N, Mean, Sum, Median, Min, Max, Std. Deviation of a measure variable, or Row / Column / Total percentage. You can show several at once (e.g. count and column percentage together).
- Compare column proportions — adds a column-proportions z-test (Bonferroni adjusted) to test whether column percentages differ.
Output. The pivot table you described, with margins computed over the margin cases, and (if requested) a Column Proportions Comparisons table.
Example. StudyZone (rows) × Sex (columns) showing the mean SystolicBP in each cell; or SmokingStatus (rows) × Hypertensive (columns) showing count and column percentage together, with a column-proportions test.
Multiple Response
When to use it. When a "pick all that apply" question is stored across several variables — either as a set of yes/no dichotomies (one variable per option) or as several variables sharing a common category coding.
Dialog. Move the variables of the response set in, and choose the set type:
- Dichotomy (default) — each variable is a yes/no flag; set the counted value that means "selected" (default 1).
- Category — the variables share a category coding; the table pools the distinct categories across them.
Output. A frequency table over the set: for each option/category, the count, the percent of responses and the percent of cases. A case counts as valid if it is non-missing on at least one variable in the set.
Example. If several columns recorded different reported symptoms as yes/no, a dichotomy multiple-response table shows how often each symptom was reported, both as a share of all responses and as a share of participants.
See also
- Crosstabs — for the standard two-variable contingency table with chi-square and association measures.