Compute additional index column in table

Hi, SPSS users,

DATA LIST FREE (",")/ sex age answer.

BEGIN DATA

1,1,2

1,2,2

1,1,2

1,2,1

1,1,2

2,2,1

2,1,1

2,2,2

2,1,1

2,2,1

END DATA.

VALUE LABELS sex 1 'Male' 2 'Female'.

VALUE LABELS age 1 'Young' 2 'Old'.

VALUE LABELS answer 1 'Yes' 2 'No'.

FORMATS sex age answer (F1).

CTABLES 

  /TABLE answer BY (sex + age) [COUNT 'N' F40, COLPCT '%' F40.1]

  /CATEGORIES VARIABLES = sex TOTAL = YES LABEL = 'Total' POSITION = BEFORE

  /CATEGORIES VARIABLES = h1 [OTHERNM] TOTAL = YES LABEL = 'Total' POSITION = BEFORE.

* In the table I want to insert columns that compute an index;

as an example it is calculated as last % value in the first row (60%) divided by % value of column "Total" (50%) times 100 = 120

Does anybody know how to do it?.

Thanks for any help!

Mario Giesel

Munich, Germany

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