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
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.