Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Replace missing values by 0
From
"Nick Cox" <[email protected]>
To
<[email protected]>
Subject
RE: st: Replace missing values by 0
Date
Mon, 9 Aug 2010 16:20:13 +0100
Should be
replace `x' = 0 if missing(`x')
Nick
[email protected]
-----Original Message-----
From: Nick Cox
I have one specific and one general comment here.
Specifically, Martin is correct to underline that . is not the only missing value, but the loop in question is easily fixed by
foreach x of varlist prean pa_kurn{
replace `x' = 0 if missing(x)
}
Generally, a minimal -search missing- points to several resources. One of the very first entries, to [I] missing values, answers this question comprehensively, so it is difficult to see why it was felt necessary to send it to Statalist.
Nick
[email protected]
Martin Weiss
============
Stata even forgives the missing blank after -if-! Amazing!
*************
clear*
inp prean pa_kurn
2 3
. 5
. 3
. .
4 5
end
foreach x of varlist prean pa_kurn{
replace `x' = 0 if(`x' == .)
}
l
*************
One problem with this "first-principles" approach is that you have to compare explicitly with all missing values, i.e. also the extended ones.
-recode- can help avoid this problem.
Neil Shephard
=============
foreach x of varlist prean pa_kurn{
replace `x' = 0 if(`x' == .)
}
...is one way to skin this cat.
Martin Weiss
============
clear*
input myvar
1
3
5
.
3
6
7
end
recode myvar (mis = 0)
l
Tirthankar Chakravarty
-mvencode-
Tobias Friedli
> I have two variabled called "prean" and "pa_kum" that contain missing values.
> These missing values i would like to replace by 0 (zero). What command can i
> use to do this?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/