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: How to fill up empty cells?
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: How to fill up empty cells?
Date
Tue, 21 Jan 2014 13:18:06 +0000
This is an FAQ.
FAQ . . . . . . . . . . . . . . . . . . . . . . . Replacing missing values
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
1/12 How can I replace missing values with previous or
following nonmissing values or within sequences?
http://www.stata.com/support/faqs/data-management/
replacing-missing-values/
Nick
[email protected]
On 21 January 2014 13:12, Peter Bilfiger <[email protected]> wrote:
> I got the following two variables in my dataset:
>
> Number1 Number2
> 000752
> 000752
> 48239P 000752
> 000752
> 000752
> 000752
> 89351Q 893895
> 893895
> 893895
> 893895
> 893895
> ....
>
>
> I want to fill up all the empty cells so that it looks like the following:
>
> Number1 Number2
> 48239P 000752
> 48239P 000752
> 48239P 000752
> 48239P 000752
> 48239P 000752
> 48239P 000752
> 89351Q 893895
> 89351Q 893895
> 89351Q 893895
> 89351Q 893895
> 89351Q 893895
>
> Each Number1 has a corresponding Number2.
>
*
* 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/