Summary percentage tables of T2B in CTABLES

[jagadishpchary]

Hi,

I need to generate one summary table of all the agreement variables
calculating the T2B total using CTABLE syntax. I was able to generate the
frequencies table successfully - however for the percentages table all the
values are comming as 100% (base should be on total respondents).

Here is the synatax which i am using.

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.

percentage 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
/Comparetest type=prop alpha=.05.
 
I have read the forum regarding similar issue - but there is no concrete
solution given for this. Could anyone please help with the syntax in
generating the valid percentages generated on total base.

Attaching the spss file.

data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data.sav>  



--
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

[Jon Peck]

You can't do  summaries across variables with CTABLES.  To do this, you could use the STATS TABLE CALC extension command.  There is an example in its syntax help that is similar to what you want, although it from a crosstabs table, and the total is at the bottom.

On Sun, Nov 24, 2019 at 8:21 AM jagadishpchary <[hidden email]> wrote:

Hi,

I need to generate one summary table of all the agreement variables
calculating the T2B total using CTABLE syntax. I was able to generate the
frequencies table successfully - however for the percentages table all the
values are comming as 100% (base should be on total respondents).

Here is the synatax which i am using.

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.

percentage 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
/Comparetest type=prop alpha=.05.

I have read the forum regarding similar issue - but there is no concrete
solution given for this. Could anyone please help with the syntax in
generating the valid percentages generated on total base.

Attaching the spss file.

data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data.sav> 



--
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

--
===================== 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