Date:         Fri, 25 Feb 2005 11:54:11 +0000
Reply-To:     Paul Mcgeoghan <mcgeoghan@CARDIFF.AC.UK>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Paul Mcgeoghan <mcgeoghan@CARDIFF.AC.UK>
Subject:      compute problem
Content-Type: text/plain; charset=US-ASCII

Hi,

I have the following problem:
There are 20 variables Subject1 to Subject20 with values 1 if they chose the
subject and 0 if they didn't.
I want to compute a new variable where if males and females have chosen the
same combination of subjects, the value is 1; if only males choose a particular
combination of subjects, it is 2, if only females choose a particular
combination of subjects, it is 3.

So if I have for example 3 variables: Subject1 to Subject3 with data:
Row Sub1 Sub2 Sub3 Gender NewV
1         1        1        1        1         1
2         1        1        1        2         1
3         1        0        0        1         1
4         1        0        0        2         1
5         1        0        1        1         2
6         0        0        1        2         3

In the last row of data (row 6), only females chose that particular combination
whereas in row 5, only males chose that particular subject combination.

What is the easiest way of doing this in SPSS?

Paul



==================
Paul McGeoghan,
Application support specialist (Statistics and Databases),
University Systems Group (USG),
Information Services,
Cardiff University.
Tel. 02920 (875035).