Multiple response (Multiple brands, multiple options)
Locked
 
|
Dear list,
I'm trying to create a Table which will show multiple brands selected in the columns and Total Aspects selected (also multiple select) in the columns. The following is the data used: DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. SAVE OUTFILE="Tester1.sav". Each respondent can select one brand, more than one or none. Each brand selected will show 4 Aspect. The respondent can select one aspect, more than one or none. I thought to group the aspects and create a total_Aspect (1-3). Then I defined multiple response sets for the brands and the Total aspects: * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$Brands LABEL='Brands' CATEGORYLABELS=VARLABELS VARIABLES=Brand1 Brand2 Brand3 VALUE=1 /MDGROUP NAME=$AspectBrand1 LABEL='AspectBrand1' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 VALUE=1 /MDGROUP NAME=$AspectBrand2 LABEL='AspectBrand2' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 VALUE=1 /MDGROUP NAME=$AspectBrand3 LABEL='AspectBrand3' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 VALUE=1 /DISPLAY NAME=[$Brands $AspectBrand1 $AspectBrand2 $AspectBrand3]. * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$TotalAspect LABEL='TotalAspect' CATEGORYLABELS=VARLABELS VARIABLES=total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4 VALUE=1 /DISPLAY NAME=[$TotalAspect]. Finally, I used $TotalAspect, $Brands to create the following table: * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. But found out when using individual brand aspects ($AspectBrand1) that my previous numbers were inflated for each brand. * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $AspectBrand1 $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] + $AspectBrand1 BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Can anyone help me and let me know what am I doing wrong? There is another way to show these data? Thanks in advance, mils
mils
|
Re: Multiple response (Multiple brands, multiple options)
|
|
Are there supposed to be 4 brands each of which could have up to 4 aspects?
IF so, would it make sense to restructure the data to be by brand? ID, brand, A1 A2 a3 a4 ask 1 1 0 1 1 ask 2 0 0 0 0 ask 3 0 0 0 0 ask 4 0 1 0 1 fkl 1 0 0 0 0 fkl 2 1 0 0 1 fkl 3 0 0 0 0 fkl 4 0 1 0 1 etc. Melissa -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of mils Sent: Wednesday, March 06, 2013 11:09 AM To: [hidden email] Subject: [SPSSX-L] Multiple response (Multiple brands, multiple options) Dear list, I'm trying to create a Table which will show multiple brands selected in the columns and Total Aspects selected (also multiple select) in the columns. The following is the data used: DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. SAVE OUTFILE="Tester1.sav". Each respondent can select one brand, more than one or none. Each brand selected will show 4 Aspect. The respondent can select one aspect, more than one or none. I thought to group the aspects and create a total_Aspect (1-3). Then I defined multiple response sets for the brands and the Total aspects: * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$Brands LABEL='Brands' CATEGORYLABELS=VARLABELS VARIABLES=Brand1 Brand2 Brand3 VALUE=1 /MDGROUP NAME=$AspectBrand1 LABEL='AspectBrand1' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 VALUE=1 /MDGROUP NAME=$AspectBrand2 LABEL='AspectBrand2' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 VALUE=1 /MDGROUP NAME=$AspectBrand3 LABEL='AspectBrand3' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 VALUE=1 /DISPLAY NAME=[$Brands $AspectBrand1 $AspectBrand2 $AspectBrand3]. * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$TotalAspect LABEL='TotalAspect' CATEGORYLABELS=VARLABELS VARIABLES=total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4 VALUE=1 /DISPLAY NAME=[$TotalAspect]. Finally, I used $TotalAspect, $Brands to create the following table: * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. But found out when using individual brand aspects ($AspectBrand1) that my previous numbers were inflated for each brand. * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $AspectBrand1 $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] + $AspectBrand1 BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Can anyone help me and let me know what am I doing wrong? There is another way to show these data? Thanks in advance, mils ----- mils -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Multiple-response-Multiple-brands-multiple-options-tp5718413.html Sent from the SPSSX Discussion mailing list archive at 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 PRIVILEGED AND CONFIDENTIAL INFORMATION This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance. ===================== 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 |
Re: Multiple response (Multiple brands, multiple options)
|
In reply to this post by mils
Not sure exactly what you want, but does this help? DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. format brand1 to total_Aspect_4 (f2.0). mult resp groups = brands (brand1 to brand3 (1)) aspects (aspect_1_3 to aspect_3_4 (1)) totals (total_Aspect_1 to total_Aspect_4(1)) /freq brands to totals. mult resp groups = brands (brand1 to brand3 (1)) aspects (aspect_1_3 to aspect_3_4 (1)) totals (total_Aspect_1 to total_Aspect_4(1)) /tables = brands by brands to totals /tables aspects by aspects totals /totals by totals. John F Hall (Mr) [retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com -----Original Message----- Dear list, I'm trying to create a Table which will show multiple brands selected in the columns and Total Aspects selected (also multiple select) in the columns. The following is the data used: DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. SAVE OUTFILE="Tester1.sav". Each respondent can select one brand, more than one or none. Each brand selected will show 4 Aspect. The respondent can select one aspect, more than one or none. I thought to group the aspects and create a total_Aspect (1-3). Then I defined multiple response sets for the brands and the Total aspects: * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$Brands LABEL='Brands' CATEGORYLABELS=VARLABELS VARIABLES=Brand1 Brand2 Brand3 VALUE=1 /MDGROUP NAME=$AspectBrand1 LABEL='AspectBrand1' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 VALUE=1 /MDGROUP NAME=$AspectBrand2 LABEL='AspectBrand2' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 VALUE=1 /MDGROUP NAME=$AspectBrand3 LABEL='AspectBrand3' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 VALUE=1 /DISPLAY NAME=[$Brands $AspectBrand1 $AspectBrand2 $AspectBrand3]. * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$TotalAspect LABEL='TotalAspect' CATEGORYLABELS=VARLABELS VARIABLES=total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4 VALUE=1 /DISPLAY NAME=[$TotalAspect]. Finally, I used $TotalAspect, $Brands to create the following table: * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. But found out when using individual brand aspects ($AspectBrand1) that my previous numbers were inflated for each brand. * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $AspectBrand1 $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] + $AspectBrand1 BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Can anyone help me and let me know what am I doing wrong? There is another way to show these data? Thanks in advance, mils ----- mils -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Multiple-response-Multiple-brands-multiple-options-tp5718413.html Sent from the SPSSX Discussion mailing list archive at 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 |
Re: Multiple response (Multiple brands, multiple options)
Administrator
|
In reply to this post by Melissa Ives
"it make(s) sense to restructure the data to be by brand" !!
As such: VARSTOCASES /MAKE Brand FROM Brand1 Brand2 Brand3 /MAKE Aspect1 FROM Aspect_1_1 Aspect_2_1 Aspect_3_1 /MAKE Aspect2 FROM Aspect_1_2 Aspect_2_2 Aspect_3_2 /MAKE Aspect3 FROM Aspect_1_3 Aspect_2_3 Aspect_3_3 /MAKE Aspect4 FROM Aspect_1_4 Aspect_2_4 Aspect_3_4 /INDEX=Index1(Brand) /KEEP=Id /NULL=KEEP. What you do with the totals? Well pal, yer on yer own with that!
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
In reply to this post by John F Hall
Hi John,
I want to show brands and total aspects in one single table. If I run a simple tab for brand 1 and aspects chosen (Brand 1) I’ve got the following counts: * Custom Tables. CTABLES /VLABELS VARIABLES=$AspectBrand1 Brand1 DISPLAY=LABEL /TABLE $AspectBrand1 BY Brand1 [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES= $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Brand1 Count Column N % Aspect_1_1 2 66.7% Aspect_1_2 1 33.3% Aspect_1_3 1 33.3% Aspect_1_4 0 0.0% However, if I group all aspects..... compute total_Aspect_1=0. compute total_Aspect_2=0. compute total_Aspect_3=0. compute total_Aspect_4=0. if (Aspect_1_1=1 or Aspect_2_1 or Aspect_3_1) total_Aspect_1=1. if (Aspect_1_2=1 or Aspect_2_2 or Aspect_3_2) total_Aspect_2=1. if (Aspect_1_3=1 or Aspect_2_3 or Aspect_3_3) total_Aspect_3=1. if (Aspect_1_4=1 or Aspect_2_4 or Aspect_3_4) total_Aspect_4=1. Exe. And run the same tab for brand 1, but this time with total aspects, I get more counts: Brand1 Count Column N % total_Aspect_1 5 100.0% total_Aspect_2 2 40.0% total_Aspect_3 2 40.0% total_Aspect_4 1 20.0% How can I create a table that group all brands and all aspects together and shows the correct counts for aspects chosen for each brand? Thanks in advance, Mils
mils
|
Re: Multiple response (Multiple brands, multiple options)
|
|
Mils It would help if you explained what exactly you are trying to do, and why. Also you should leave the original replies in the mail so others can follow the thread. My syntax was tested and works on the data you sent. Sometimes it's a good idea to create a blank table and then explain exactly what you want in each cell. You only have about 40 cases in total: is it really worth analysing the data? John John F Hall (Mr) [retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com PS I’ve put my initial reply back in below: Not sure exactly what you want, but does this help ? [tested and working] File > new > syntax Copy all this in: DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. format brand1 to total_Aspect_4 (f2.0). mult resp groups = brands (brand1 to brand3 (1)) aspects (aspect_1_3 to aspect_3_4 (1)) totals (total_Aspect_1 to total_Aspect_4(1)) /freq brands to totals. mult resp groups = brands (brand1 to brand3 (1)) aspects (aspect_1_3 to aspect_3_4 (1)) totals (total_Aspect_1 to total_Aspect_4(1)) /tables = brands by brands to totals /tables aspects by aspects totals /totals by totals. Run > All. -----Original Message----- Dear list, I'm trying to create a Table which will show multiple brands selected in the columns and Total Aspects selected (also multiple select) in the columns. The following is the data used: DATA LIST LIST / Id(A4) Brand1 Brand2 Brand3 Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4. BEGIN DATA. ask 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 1 fkl 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 ejk 1 0 1 1 0 1 0 0 0 0 0 0 1 0 0 1 1 1 0 eiw 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 woq 1 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 peo 0 1 1 0 0 0 0 0 0 1 1 0 1 1 0 0 1 1 1 oep 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 iwq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 fjs 1 1 1 0 1 0 0 1 1 1 0 0 0 1 0 1 1 1 0 ska 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 END DATA. SAVE OUTFILE="Tester1.sav". Each respondent can select one brand, more than one or none. Each brand selected will show 4 Aspect. The respondent can select one aspect, more than one or none. I thought to group the aspects and create a total_Aspect (1-3). Then I defined multiple response sets for the brands and the Total aspects: * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$Brands LABEL='Brands' CATEGORYLABELS=VARLABELS VARIABLES=Brand1 Brand2 Brand3 VALUE=1 /MDGROUP NAME=$AspectBrand1 LABEL='AspectBrand1' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_1_1 Aspect_1_2 Aspect_1_3 Aspect_1_4 VALUE=1 /MDGROUP NAME=$AspectBrand2 LABEL='AspectBrand2' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_2_1 Aspect_2_2 Aspect_2_3 Aspect_2_4 VALUE=1 /MDGROUP NAME=$AspectBrand3 LABEL='AspectBrand3' CATEGORYLABELS=VARLABELS VARIABLES=Aspect_3_1 Aspect_3_2 Aspect_3_3 Aspect_3_4 VALUE=1 /DISPLAY NAME=[$Brands $AspectBrand1 $AspectBrand2 $AspectBrand3]. * Define Multiple Response Sets. MRSETS /MDGROUP NAME=$TotalAspect LABEL='TotalAspect' CATEGORYLABELS=VARLABELS VARIABLES=total_Aspect_1 total_Aspect_2 total_Aspect_3 total_Aspect_4 VALUE=1 /DISPLAY NAME=[$TotalAspect]. Finally, I used $TotalAspect, $Brands to create the following table: * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. But found out when using individual brand aspects ($AspectBrand1) that my previous numbers were inflated for each brand. * Custom Tables. CTABLES /VLABELS VARIABLES=$TotalAspect $AspectBrand1 $Brands DISPLAY=LABEL /TABLE $TotalAspect [C] + $AspectBrand1 BY $Brands [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES=$TotalAspect $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Can anyone help me and let me know what am I doing wrong? There is another way to show these data? Thanks in advance, mils ----- mils -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Multiple-response-Multiple-brands-multiple-options-tp5718413.html Sent from the SPSSX Discussion mailing list archive at 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 -----Original Message----- Hi John, I want to show brands and total aspects in one single table. If I run a simple tab for brand 1 and aspects chosen (Brand 1) I’ve got the following counts: * Custom Tables. CTABLES /VLABELS VARIABLES=$AspectBrand1 Brand1 DISPLAY=LABEL /TABLE $AspectBrand1 BY Brand1 [C][COUNT F40.0, COLPCT.COUNT PCT40.1] /CATEGORIES VARIABLES= $AspectBrand1 $Brands EMPTY=INCLUDE TOTAL=YES POSITION=AFTER. Brand1 Count Column N % Aspect_1_1 2 66.7% Aspect_1_2 1 33.3% Aspect_1_3 1 33.3% Aspect_1_4 0 0.0% However, if I group all aspects..... compute total_Aspect_1=0. compute total_Aspect_2=0. compute total_Aspect_3=0. compute total_Aspect_4=0. if (Aspect_1_1=1 or Aspect_2_1 or Aspect_3_1) total_Aspect_1=1. if (Aspect_1_2=1 or Aspect_2_2 or Aspect_3_2) total_Aspect_2=1. if (Aspect_1_3=1 or Aspect_2_3 or Aspect_3_3) total_Aspect_3=1. if (Aspect_1_4=1 or Aspect_2_4 or Aspect_3_4) total_Aspect_4=1. Exe. And run the same tab for brand 1, but this time with total aspects, I get more counts: Brand1 Count Column N % total_Aspect_1 5 100.0% total_Aspect_2 2 40.0% total_Aspect_3 2 40.0% total_Aspect_4 1 20.0% How can I create a table that group all brands and all aspects together and shows the correct counts for aspects chosen for each brand? Thanks in advance, Mils ----- mils -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Multiple-response-Multiple-brands-multiple-options-tp5718413p5718433.html Sent from the SPSSX Discussion mailing list archive at 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 |
Re: Multiple response (Multiple brands, multiple options)
|
Administrator
|
OP needs to produce the specific table he/she wants.
Also it seems did not bother to look at the restructuring advice. Dealing meaningfully with MR x MR is a flustercluck IMNSHO. Seems such malady is restricted to Marketing Research in particular and usually due to inane "design" of data structures! Just because a single individual dumps a butt load of data does NOT mean it ALL belongs on ONE line!!! Long is good wide is a PITA!!
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
| Free forum by Nabble | Edit this page |