Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash
Code: Select all
CTABLES
/VLABELS VARIABLES=x y DISPLAY=DEFAULT
/TABLE x [COUNT F40.0] BY y
/CATEGORIES VARIABLES=x y ORDER=A KEY=VALUE EMPTY=EXCLUDE
TOTAL=YES POSITION=BEFORE.
Code: Select all
Total B C
B1 B2 C1 C2
S3. ABCDE Total Respondents n n n n n
A1 % % % % %
A2 % % % % %
A3 % % % % %
A4 % % % % %
A5 % % % % %
Total Total % % % % %
Code: Select all
CTABLES
/VLABELS VARIABLES=B C ABCDE DISPLAY=DEFAULT
/TABLE ABCDE [TABLEPCT.COUNT PCT40.1, TOTALS[COUNT F40.0, TABLEPCT.COUNT PCT40.1]] BY B [C] + C [C]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=B ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=BEFORE
/CATEGORIES VARIABLES=C ORDER=A KEY=VALUE EMPTY=EXCLUDE
/CATEGORIES VARIABLES=ABCDE ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER.
Code: Select all
recode ABCDE (sysmis=sysmis) (else=1) into NNN.
exec.
CTABLES
/VLABELS VARIABLES=B C NNN ABCDE DISPLAY=DEFAULT
/TABLE NNN [COUNT F40.0] + ABCDE [TABLEPCT.COUNT PCT40.1] BY B [C] + C [C]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=B ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=BEFORE
/CATEGORIES VARIABLES=C ORDER=A KEY=VALUE EMPTY=EXCLUDE
/CATEGORIES VARIABLES=ABCDE ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER.
Code: Select all
/SLABELS POSITION={ROW/COLUMN} [VISIBLE={YES/NO}]
Code: Select all
ABCDE [TABLEPCT.COUNT '' PCT40.1]
Code: Select all
/SLABELS POSITION={ROW/COLUMN} [VISIBLE={YES/NO}
Sorry Dhufan, we can't go father with our both misunderstandingdhufan dhafani wrote:2. "Multiple Response sets" is where respondent can answer more than one answer (multiple answer). how i can modified the script/ syntax for the case ?
Code: Select all
CTABLES
/VLABELS VARIABLES=ABCDE DISPLAY=DEFAULT
/TABLE ABCDE [COUNT F40.0, COLPCT.COUNT PCT40.1, RESPONSES F40.0, COLPCT.RESPONSES PCT40.1]
/CATEGORIES VARIABLES=ABCDE ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES
POSITION=AFTER.
Users browsing this forum: No registered users and 1 guest