CTABLES Data Summarization (PSPP)

15.7.2 Data Summarization

The CTABLES command allows the user to control how the data are summarized with summary specifications, syntax that lists one or more summary function names, optionally separated by commas, and which are enclosed in square brackets following a variable name on the TABLE subcommand. When all the variables are categorical, summary specifications can be given for the innermost nested variables on any one axis. When a scalar variable is present, only the scalar variable may have summary specifications.

The following example includes a summary specification for column and row percentages for categorical variables, and mean and median for a scalar variable:

CTABLES
    /TABLE=age [MEAN, MEDIAN] BY gender
    /TABLE=ageGroup [COLPCT, ROWPCT] BY gender.

Custom Tables
	S3a. GENDER:
	Male		Female
	Mean	Median	Mean	Median
D1. AGE: What is your age?	46	45	50	52

Custom Tables
		S3a. GENDER:
		Male		Female
		Column %	Row %	Column %	Row %
Age group	15 or younger	.0%	.	.0%	.
	16 to 25	19.0%	54.0%	13.1%	46.0%
	26 to 35	15.2%	49.2%	12.7%	50.8%
	36 to 45	15.6%	47.2%	14.2%	52.8%
	46 to 55	16.8%	44.8%	16.8%	55.2%
	56 to 65	16.5%	41.4%	18.9%	58.6%
	66 or older	17.0%	36.0%	24.4%	64.0%

A summary specification may override the default label and format by appending a string or format specification or both (in that order) to the summary function name. For example:

CTABLES /TABLE=ageGroup [COLPCT 'Gender %' PCT5.0,
                         ROWPCT 'Age Group %' PCT5.0]
               BY gender.

Custom Tables
		S3a. GENDER:
		Male		Female
		Gender %	Age Group %	Gender %	Age Group %
Age group	15 or younger	0%	.	0%	.
	16 to 25	19%	54%	13%	46%
	26 to 35	15%	49%	13%	51%
	36 to 45	16%	47%	14%	53%
	46 to 55	17%	45%	17%	55%
	56 to 65	16%	41%	19%	59%
	66 or older	17%	36%	24%	64%

In addition to the standard formats, CTABLES allows the user to specify the following special formats:

`NEGPARENw.d`	Encloses negative numbers in parentheses.	`42.96`	`(42.96)`
`NEQUALw.d`	Adds a `N=` prefix.	`N=42.96`	`N=-42.96`
`PARENw.d`	Encloses all numbers in parentheses.	`(42.96)`	`(-42.96)`
`PCTPARENw.d`	Encloses all numbers in parentheses with a ‘`%`’ suffix.	`(42.96%)`	`(-42.96%)`

Parentheses provide a shorthand to apply summary specifications to multiple variables. For example, both of these commands:

CTABLES /TABLE=ageGroup[COLPCT] + membersOver16[COLPCT] BY gender.
CTABLES /TABLE=(ageGroup + membersOver16)[COLPCT] BY gender.

produce the same output shown below:

Custom Tables
		S3a. GENDER:
		Male	Female
		Column %	Column %
Age group	15 or younger	.0%	.0%
	16 to 25	19.0%	13.1%
	26 to 35	15.2%	12.7%
	36 to 45	15.6%	14.2%
	46 to 55	16.8%	16.8%
	56 to 65	16.5%	18.9%
	66 or older	17.0%	24.4%
S1. Including yourself, how many members of this household are age 16 or older?	None	.0%	.0%
	1	21.4%	35.0%
	2	61.9%	52.3%
	3	11.0%	8.2%
	4	4.2%	3.2%
	5	1.1%	.9%
	6 or more	.4%	.4%

The following sections list the available summary functions. After each function’s name is given its default label and format. If no format is listed, then the default format is the print format for the variable being summarized.