Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index