I am using a ctab macro from Raynald Levesque site, which goes like this
DEFINE !ctable(row=!CHAREND('/') /col=!CMDEND)
/VLABELS VARIABLES= !row !col DISPLAY=DEFAULT
/TABLE !HEAD(!row) !DO !v !IN (!TAIL(!row)) + !v !DOEND
BY (!HEAD(!col) !DO !v !IN (!TAIL(!col)) + !v !DOEND ) [COLPCT.COUNT PCT40.0, TOTALS[COUNT F40.0]]
/CATEGORIES VARIABLES= !row ORDER=A KEY=VALUE EMPTY=EXCLUDE
/CATEGORIES VARIABLES=!col ORDER=A KEY=VALUE EMPTY=INCLUDE.
This is working fine for the normal custom table I run by Recalling the macro by statements given below.
!ctable row=varlist /col=D3.
Now, I want to give an additional condition where I can exclude any categories that have less than 10 responses. How can I do that? Any help in this regard would be appreciated.
I am using version 11.5 of SPSS.
Advertise on Talk Stats