Problem with running Multiple response Frequencies with Custom Tables

[Ratna Wynn-2]

Hi!
 
I am working of SPSS 18 and have custom tables. I defined a mutliple response set as below. And wanted to run the frequencies and nets via custom tables. However the set defined does not show up as a variable. Does anyone know how I can access this set via the custom tables dialog box. Is there something new in Version 18 that prevents me from seeing set. I can run via syntax but wanted to know if there was a way to do it via menus.
 
* Define Multiple Response Sets.
MRSETS
  /MCGROUP NAME=$Q13_OE VARIABLES=Q13Code1 Q13Code2 Q13Code3 Q13Code4
  /DISPLAY NAME=[$Q13_OE].
 

CTABLES
  /VLABELS VARIABLES=test $Q13_OE DISPLAY=DEFAULT
  /TABLE $Q13_OE BY test [COLPCT.COUNT PCT40.2]
  /CATEGORIES VARIABLES=test ORDER=A KEY=VALUE EMPTY=EXCLUDE
  /CATEGORIES VARIABLES=$Q13_Oe [100 thru 113 SUBTOTAL='EFFICACY NET', 200 thru 212, SUBTOTAL='SAFETY NET', 300 THRU 311, SUBTOTAL='MOA NET', 400.00 THRU 402, SUBTOTAL='COST net', 500 THRU 506, SUBTOTAL = 'DOSING NET', 995, SUBTOTAL='OTHER', 996, SUBTOTAL='NONE',OTHERNM] EMPTY=INCLUDE
  POSITION=AFTER.

Any help would be greatly appreciated.
 
Thanks,
 
Ratna

[Ratna Wynn-2]

Hi

 

Thanks for the references. I will review to see if I can find some answers there. I am defining the sets each time. But right after I run the sets I go to the menu Analyze > Cutom Tables. In the window that opens up in the left panel I expect to see the set I defined as a variable with a $ sign before it so $Q13_OE but I don't see it. I recall that in SPSS 14 you defined the set using Analyze> Multiple Response Set and then subsequently went to analyze > custom tables the set showed  up at the bottom of the left variable panel. You could them pull that set variable into the row and in a separate tab define how you wanted the codes netted. I am unable to do this anymore through the menus. I hope this helps with providing more perspective.

 

I am able to get the result I want but was wondering if there was a way to do this through menus in SPSS 18.

Thanks,

 

Ratna

On Tue, Sep 28, 2010 at 4:14 PM, Ratna Wynn <[hidden email]> wrote:

Hi!
 
I am working of SPSS 18 and have custom tables. I defined a mutliple response set as below. And wanted to run the frequencies and nets via custom tables. However the set defined does not show up as a variable. Does anyone know how I can access this set via the custom tables dialog box. Is there something new in Version 18 that prevents me from seeing set. I can run via syntax but wanted to know if there was a way to do it via menus.
 
* Define Multiple Response Sets.
MRSETS
  /MCGROUP NAME=$Q13_OE VARIABLES=Q13Code1 Q13Code2 Q13Code3 Q13Code4
  /DISPLAY NAME=[$Q13_OE].
 

CTABLES
  /VLABELS VARIABLES=test $Q13_OE DISPLAY=DEFAULT
  /TABLE $Q13_OE BY test [COLPCT.COUNT PCT40.2]
  /CATEGORIES VARIABLES=test ORDER=A KEY=VALUE EMPTY=EXCLUDE
  /CATEGORIES VARIABLES=$Q13_Oe [100 thru 113 SUBTOTAL='EFFICACY NET', 200 thru 212, SUBTOTAL='SAFETY NET', 300 THRU 311, SUBTOTAL='MOA NET', 400.00 THRU 402, SUBTOTAL='COST net', 500 THRU 506, SUBTOTAL = 'DOSING NET', 995, SUBTOTAL='OTHER', 996, SUBTOTAL='NONE',OTHERNM] EMPTY=INCLUDE
  POSITION=AFTER.

Any help would be greatly appreciated.
 
Thanks,
 
Ratna