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 (October 2001, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 22 Oct 2001 18:43:15 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Replace missing value by 0
Comments: To: "Isson, Jean-Paul" <Jean-Paul.Isson@MICROCELL.CA>
Content-type: text/plain; charset=iso-8859-1

Before asking why you want to replace missing with zero, may I suggest that before using this data. you issue statement option missing='0' ; Then you get 0 instead of . when results are displayed/printed and you don't need to rebuild all your data.

(And those rows with missing values won't contribute to statistics like mean, where 0 might not be the correct interpretation)

good luck Peter Crawford

Datum: 22/10/2001 16:40 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: "Isson, Jean-Paul" <Jean-Paul.Isson@MICROCELL.CA>

Betreff: Replace missing value by 0 Nachrichtentext:

Hi every body, I would like to replace missing data on some of numeric variables in my data set by 0. This will concern about 150 variables in my data set. I think that this should be done without using 150 times if var1=. then var1=0. and so on.. Does any one know how to do that .In SPSS I used recode function. But now I am working with SAS.

Thanks for any hint or help.

--------------------------------------------------------------- Jean-Paul Isson Customer Behavior Modelling

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


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