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 (August 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 12 Aug 2002 21:53:04 +1000
Reply-To:   Sabina Schnelle <Sabina@work.asn.au>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   Sabina Schnelle <Sabina@work.asn.au>
Subject:   recoding/ condensing
Content-Type:   text/plain; charset="iso-8859-1"

Hello fellow listers. Another newbie question: I have two corresponding variables (b101sat c101sat); per case, only one of them has a value. In order to condense them into one variable (b101all) I use the following syntax RECODE b101sat c101sat (SYSMIS=96) (0=0) (1=1) (2=2) (3=3) (4=4) INTO b101miss c101miss . VARIABLE LABELS b101miss 'Overall Satisfaction Employees w/ missing values' /c101miss 'Overall Satisfaction Mgmt w/ missing values'. EXECUTE . COMPUTE b101all = b101miss + c101miss - 96 . VARIABLE LABELS b101all 'Overall satisfaction of all respondents (employee &'+ ' mgmt)' . EXECUTE . I have about 200 of those corresponding pairs and cannot imagine that this makes the sheet very clear/ practicable ... though it worked. Is there a way to avoid the detour of displaying the two (useless) new variables (b101miss c101miss)? - I tried simply overwriting the original variables (b101sat c101sat) with the following syntax RECODE b101sat (SYSMIS=96) (0=0) (1=1) (2=2) (3=3) (4=4) . EXECUTE . RECODE c101sat (SYSMIS=96) (0=0) (1=1) (2=2) (3=3) (4=4) . EXECUTE . COMPUTE b101all = b101sat + c101sat - 96 . VARIABLE LABELS b101all 'Overall satisfaction of all respondents (employee &'+ ' mgmt)' . EXECUTE . But this left me with ALL cases as 'system missing' in the computed variable (b101all) - does anyone see my blatant (?) mistake? Any help greatly appreciated- and many thx for your patience. Sabina


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