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: Creating new variable from existing observations
From
Suryadipta Roy <[email protected]>
To
[email protected]
Subject
Re: st: Creating new variable from existing observations
Date
Sat, 9 Jun 2012 16:19:29 -0400
Nick,
I did read the FAQ, but missed the reversing time part. Reversing time
did the trick! Thank you so much!
Sincerely,
Suryadipta.
On Sat, Jun 9, 2012 at 1:51 PM, Nick Cox <[email protected]> wrote:
> This is an FAQ. See
>
> FAQ . . . . . . . . . . . . . . . . . . . . . . . Replacing missing values
> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
> 2/03 How can I replace missing values with previous or
> following nonmissing values?
> http://www.stata.com/support/faqs/data/missing.html
>
> For what you seem to want, you would need to reverse time.
>
>
> On Sat, Jun 9, 2012 at 6:47 PM, Suryadipta Roy <[email protected]> wrote:
>
>> I actually had another question relating to replacing missing
>> observations for panel data. My original dataset has been sorted by
>> exporter, importer, and year. I am trying the following to replace
>> missing observations for a variable for both importer and exporter by
>> a following value for one/more years:
>>
>> by importer exporter (year), sort: replace myvar = myvar[_n+1] if myvar >= .
>>
>> However, this only replaces the value for one previous year and leaves
>> the rest unchanged. Can anyone let me know how to fix this problem and
>> replace the missing value for all previous years for all exporters and
>> importers?
>>
> *
> * 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/
*
* 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/