LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2001)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SPSSX-L page