Compute additional index column in table

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

Compute additional index column in table

Mario Giesel-2
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