SPSS CTABLE syntax - plz correct the code

[jagadishpchary]

Dear All,

My query is: I need to run a table in SPSS using the Ctable syntax in the
same format as stated in the below screen shot.
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_format.jpg>
Also, I am attaching the SPSS code and data set which I am referring too.
Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Data.sav>  
Table_syntax.sps
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_syntax.sps>  

Note that, I am able to successfully generate the table in the required
format however the results populated from SPSS using the attached syntax are
wrong.

Could anyone please correct the SPSS code so that the correct numbers are
populated.

FYI, attached the screen shot of the required table with correct results.
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_output.jpg>

Many thanks for the help in advance.

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

[Jon Peck]

Why do you think the results are wrong?  The PCOMPUTES, at least, look right to me.

On Sat, Jul 25, 2020 at 5:48 AM jagadishpchary <[hidden email]> wrote:

Dear All,

My query is: I need to run a table in SPSS using the Ctable syntax in the
same format as stated in the below screen shot.
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_format.jpg>
Also, I am attaching the SPSS code and data set which I am referring too.
Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Data.sav> 
Table_syntax.sps
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_syntax.sps> 

Note that, I am able to successfully generate the table in the required
format however the results populated from SPSS using the attached syntax are
wrong.

Could anyone please correct the SPSS code so that the correct numbers are
populated.

FYI, attached the screen shot of the required table with correct results.
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Table_output.jpg>

Many thanks for the help in advance.

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

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

The results are wrong - since the values across the each statement should add
to base value.



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

Hi. Your "Required Output" example looks weird. This is probably what you should get:

CTABLES

    /VLABELS VARIABLES=Q1r1 Q1r2 Q1r3 Q1r4 Q1r5 Q1r6 Q1r7 DISPLAY=NONE

    /PCOMPUTE &x1= EXPR([1]+[2])

    /PCOMPUTE &x2= EXPR([3]+[4]+[5])

    /PCOMPUTE &x3= EXPR([6]+[7])

    /PPROPERTIES &x1 LABEL = "B2B (NET)"

    /PPROPERTIES &x2 LABEL = "M3B (NET)"

    /PPROPERTIES &x3 LABEL = "T2B (NET)"

    /TABLE BY (Q1r1 + Q1r2 + Q1r3 + Q1r4 + Q1r5 + Q1r6 + Q1r7) [COUNT ""]

    /CLABELS COLLABELS=OPPOSITE

    /CATEGORIES VARIABLES=Q1r1 Q1r2 Q1r3 Q1r4 Q1r5 Q1r6 Q1r7 [1,2,3,4,5,6,7,&x3,&x2,&x1] TOTAL=YES POSITION=BEFORE.

Mario

Munich, Germany

Am Sonntag, 26. Juli 2020, 06:45:26 MESZ hat jagadishpchary <[hidden email]> Folgendes geschrieben:

The results are wrong - since the values across the each statement should add
to base value.

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

[Jon Peck]

I'm not clear on what you mean, but remember that multiple response sets can tally count or responses.  In particular, totals will be different.  For statement1, for example, the count statistic is 13 but there are 26 responses.

On Sat, Jul 25, 2020 at 10:44 PM jagadishpchary <[hidden email]> wrote:

The results are wrong - since the values across the each statement should add
to base value.



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

Perfect, this worked for me.

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