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]
st: can I replace with missing value with 0?
From
Ken Ning <[email protected]>
To
[email protected]
Subject
st: can I replace with missing value with 0?
Date
Mon, 19 Aug 2013 22:47:20 +0100
Hi statausers
If I am using a formula taking ln(sales) (e.g the formula--[ ln (sales
t)-ln(sales t-1) ] ) and for some years sales is zero or negative, is
there an accepted way to retain the observations for those years? For
example can you just repalce the missing result with 0.
year sales log value
2001 10010 9.21134
2002 10020 9.212338
2003 30010 10.30929
2004 0 missing (replace with 0?)
2005 14010 9.547527
2006 10555 9.264355
2007 70010 11.15639
2008 -200 missing (replace with 0?)
Many thanks
Ken
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/