Syntax adjustment

[Peter Omondi]

Dear Team,

Does any one know which syntax I can use and have a breakout of total in
between the breakouts e.g
Gender Age
Male Female Total 12-15yrs 16-20yrs 21-25yrs Total
                                               
                                               
                                               
                                               




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

[Ki Park]

If you want to show ONE row with two variables as you stated, you could use.

*This variables will allow to create the one row.
compute Call=1.
*My variables are "age" and "edu", and you should change this.
CTABLES
  /VLABELS VARIABLES= call age edu  DISPLAY=LABEL
  /TABLE call by age [C][rowPCT.VALIDN '' PCT40.1] + edu [C][rowPCT.VALIDN
'' PCT40.1]
  /CATEGORIES VARIABLES=age edu ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES
POSITION=AFTER MISSING=EXCLUDE.


Ki



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

True, but you can simplify it further by removing the call variable:

 /TABLE by age [C][rowPCT.VALIDN '' PCT40.1] + edu [C][rowPCT.VALIDN
'' PCT40.1]  

On Fri, Oct 5, 2018 at 11:18 AM Ki Park <[hidden email]> wrote:

If you want to show ONE row with two variables as you stated, you could use.

*This variables will allow to create the one row.
compute Call=1.
*My variables are "age" and "edu", and you should change this.
CTABLES
  /VLABELS VARIABLES= call age edu  DISPLAY=LABEL
  /TABLE call by age [C][rowPCT.VALIDN '' PCT40.1] + edu [C][rowPCT.VALIDN
'' PCT40.1]
  /CATEGORIES VARIABLES=age edu ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES
POSITION=AFTER MISSING=EXCLUDE.


Ki



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

[Peter Omondi]

Dear Ki Park,

The syntax has been very helpful. If I would like to include the absolutes
as well, where do I adjust. Also if I had a multiple selected question which
syntax can I use. Your assistance will be highly appreciated.

Regards,

Peter



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

[Peter Omondi]

Assuming I had the following question with Region and S2 as my breakouts,
whereby the response on this TMC question are dimension data (Yes/No)
(*TMC21 to TMC29*) and assuming we had the same multiple response question
but it's a multi group question (*Q1_1 to Q1_15*) as the range.


Multidimension question (TMC21 to TMC29)- Yes/No response
Multigroup questions (Q1_1 to Q1)15) -  Total
MRS
Mobil
Oando
Conoil
Forte Oil Plc
NNPC
NIPCO
Honeywell Oil  Gas
Ascon Oil
Rainoil Limited
Techno Oil
Capital Oil and Gas Ind
Acron Petroleum
Eterna
all the above brands are the responses.

Regards,

Peter



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

[Ki Park]

Peter,

In general, your questions can be added into the code with a "+", but it
will be hard to read them if you have a table with 29 (yes/no) questions,
plus 15 'check all that apply' questions.

I did not understand when you say "absolutes" though. Is this an absolute
mean? or something else?

Using Jon's advise, you could modify the code as:

CTABLES
  /VLABELS VARIABLES= call age edu  DISPLAY=LABEL
  /TABLE  your_break_v  by (TMC21+TMC22+TMC23+ ... + Q1_1+Q1_2+...)
[C][rowPCT.VALIDN '' PCT40.1]

Sometimes, the check all that apply questions comes in an odd format in
excel. The former code will work ONLY if all 15 variables come in the
corresponding columns. If this is not the case, you could post sample data,
so someone can help you to order your data first. I am not sure if this is
really what you need though.

Thanks.





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

[Ki Park]

CTABLES
  /VLABELS VARIABLES= ...your list of variables here...  DISPLAY=LABEL
  /TABLE  your_break_v  by (TMC21+TMC22+TMC23+ ... + Q1_1+Q1_2+...)
[C][rowPCT.VALIDN '' PCT40.1]

I realized that I still had some old codes in the "VLABELS. "

Ki





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