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 on April 23, and its replacement, is already up and running.

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

Re: st: Replace with missing value

From   Alex Olssen <>
Subject   Re: st: Replace with missing value
Date   Fri, 12 Apr 2013 20:23:42 +1000

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.

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


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?

Kind regards
*   For searches and help try:

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index