| Date: | Thu, 6 Dec 2001 18:48:18 GMT0BST |
| 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 if |
|---|
Hi,
I have data such as
VAR1 VAR2 VAR3
1 1
1 1
1
I want to do something really simple such as Compute a fourth
variable which will give me 1 (if VAR3 is 1 and VAR1 and VAR2 are
both missing).
I use Transform Compute
Target Variable VAR04
Numeric expression 1 if
VAR3=1&(VAR1~=1&VAR2~=1)
which gives me missing for all the rows in VAR4 whereas it should
give me
VAR4
.
.
1
What am I doing wrong, I think I have the logic right.
Paul
-----------------------------------------------
Paul McGeoghan
Application Support Specialist
(Statistics and databases support)
Information Services
Cardiff University
40-41 Park Place
CARDIFF
(029) 20875035
|