CTABLES Problem with /PCOMPUTE

classic Classic list List threaded Threaded
1 message Options
ThW
Reply | Threaded
Open this post in threaded view
|

CTABLES Problem with /PCOMPUTE

ThW
Hi,

I got a problem concerning the /PCOMPUTE-function for Custom Tables:

I built a table for an evaluation scale from 1 to 6 for different items in columns. At the bottom of each item, after the column percents of the categories, I calculated TOP2-boxes (1+2):

CTABLES
/PCOMPUTE &topboxes = EXPR( [1] + [2] )
/PPROPERTIES &topboxes LABEL = "Top Boxes (1+2)"FORMAT=COUNT F40.0 HIDESOURCECATS=NO
/TABLE BY (V_1 + V_2 + V_3) [ COLPCT.COUNT F40.0 COUNT F40.0 ]
/CLABELS COLLABELS=OPPOSITE
/CATEGORIES VARIABLES=V_1 V_2 V_3 [ 1 2 3 4 5 6  &topboxes] total=YES position=after.


Whenever I concatenate two or more categorial variables and the first one has values in at least one category, but the second or third has no cases inside (e.g. if no one rated item V_2 or V_3) in the second or third column appear the values for computed category "&topboxes" from column 1 resp. 2. And: I do not want to exclude this columns.

Any suggestions?
Thomas
Research Manager