Hello All,
Just need a help on the syntax - though it is simple unable to solve it.
I am trying to generate 2 tables i.e. frequencies and percentages tables.
here is the syntax
frequencies syntax:
Ctables
/VLABELS VARIABLES=Q3r3_1,Q5r3c1_1 DISPLAY=label
/VLABELS VARIABLES=TOTAL DISPLAY=none
/TABLE (TOTAL+Q8r6+Q8r7)[C] [COUNT] by (Q3r3_1+Q5r3c1_1)
/SLABELS POSITION=COLUMN VISIBLE=NO
/CATEGORIES VARIABLES=Q3r3_1,Q5r3c1_1 TOTAL=NO
/CATEGORIES VARIABLES=Q8r6,Q8r7 [HSUBTOTAL="T2B", 1 thru 2] POSITION=BEFORE
.
percentages syntax:
Ctables
/VLABELS VARIABLES=Q3r3_1,Q5r3c1_1 DISPLAY=label
/VLABELS VARIABLES=TOTAL DISPLAY=none
/TABLE TOTAL+(Q8r6+Q8r7)[C] [COLPCT.COUNT] by (Q3r3_1+Q5r3c1_1)
/SLABELS POSITION=row VISIBLE=NO
/CATEGORIES VARIABLES=Q3r3_1,Q5r3c1_1 TOTAL=NO
/CATEGORIES VARIABLES=Q8r6,Q8r7 [HSUBTOTAL="T2B", 1 thru 2] POSITION=BEFORE
.
I am fine with the frequencies table(table 1) . However when i run the
percentages syntax the values are coming as 100% (table 2) - attached the
table.
Book3.xlsx
<
http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Book3.xlsx>
spss data file:
data.sav
<
http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data.sav>
Could any one please solve this issue.
Regards,
Jagadish
--
Sent from:
http://spssx-discussion.1045642.n5.nabble.com/=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
