CTABLES syntax help

[jagadishpchary]

Hi,

I am trying to generate the percentages tables for the variable Q8r6. The
question is, i need to have the base i.e. (total respondents) to display the
counts whereas the attributes should have the percentages values. I have the
used the syntax [COLPCT, TOTAL [COUNT]] for most of the tables and it worked
fine for me. However i am not sure is it because i am using HSUBTOTAL?
Please help me the code.  

Ctables
/VLABELS VARIABLES=Q3r3_1,Q5r3c1_1 DISPLAY=label
/TABLE (Q8r6)[C] [COLPCT, TOTAL [COUNT]] by (Q3r3_1+Q5r3c1_1)  
/SLABELS POSITION=row VISIBLE=NO
/CATEGORIES VARIABLES=Q3r3_1,Q5r3c1_1  TOTAL=NO
/CATEGORIES VARIABLES=Q8r6 [HSUBTOTAL="T2B", 1 thru 2, HSUBTOTAL="L2B", 3
thru 7] total=yes  POSITION=BEFORE label = "total repondents"
/Comparetest type=prop alpha=.05.

Attached the spss dataset
data_-_Copy.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data_-_Copy.sav>  

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

[Jon Peck]

I am not clear on what you want,  but if you just write TOTAL[COUNT COLPCT] you will get both statistics.

On Sat, Nov 30, 2019 at 10:59 PM jagadishpchary <[hidden email]> wrote:

Hi,

I am trying to generate the percentages tables for the variable Q8r6. The
question is, i need to have the base i.e. (total respondents) to display the
counts whereas the attributes should have the percentages values. I have the
used the syntax [COLPCT, TOTAL [COUNT]] for most of the tables and it worked
fine for me. However i am not sure is it because i am using HSUBTOTAL?
Please help me the code. 

Ctables
/VLABELS VARIABLES=Q3r3_1,Q5r3c1_1 DISPLAY=label
/TABLE (Q8r6)[C] [COLPCT, TOTAL [COUNT]] by (Q3r3_1+Q5r3c1_1)   
/SLABELS POSITION=row VISIBLE=NO
/CATEGORIES VARIABLES=Q3r3_1,Q5r3c1_1  TOTAL=NO
/CATEGORIES VARIABLES=Q8r6 [HSUBTOTAL="T2B", 1 thru 2, HSUBTOTAL="L2B", 3
thru 7] total=yes  POSITION=BEFORE label = "total repondents"
/Comparetest type=prop alpha=.05.

Attached the spss dataset
data_-_Copy.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data_-_Copy.sav> 

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

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

[jagadishpchary]

Hi Jon,

thanks for the reply.

I need to generate table with percentages but base with counts i.e. total
respondents.

attached the table with required format.
Book3.xlsx

  Aware brand1 Aware brand2
Aware Not Aware Aware Not Aware
Q8r6 total repondents 22 18 22 18
  T2B 18% 22% 27% 11%
  L2B 82% 78% 73% 89%

However when i used the syntax [COLPCT, TOTAL [COUNT]] i am unable to
generate the table
Please help me with the code.

Regards,
Jagadish
 




--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[e-mail] (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