Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Replace with missing value


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Replace with missing value
Date   Fri, 12 Apr 2013 11:44:49 +0100

If there is a missing value in the first 30 days, values should also
be set to missing for days between that date and day 30.

Nick
njcoxstata@gmail.com


On 12 April 2013 11:23, Alex Olssen <alex.olssen@gmail.com> wrote:
> Here is an example. You can check that it does what you want. You must be
> careful about the first 30 observations. I only start your replacing from
> the 31st days.  You can manually adjust this part to suit your needs.
>
> clear
> set seed 1
> set obs 10000
> gen days = _n
> gen x = round(100 * runiform())
> gen y = round(100 * runiform())
> replace y = . if y > 95
> tsset days
> forvalues d = 1/30 {
>   replace x = . if L`d'.y == . in 31/l
> }
>
> Regards,
> Alex
>
>
> On 12/04/13 7:35 PM, André Gyllenram wrote:
>>
>> So i have a simple problem. I have a time series and two variables. I have
>> a variable that is nonmissing and i would like to replace it with a missing
>> value if my other variable has a missing value somwhere during the last 30
>> days. Can anyone help me?

*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index