How do you know that x is 4 for id == 1 in Data 1? That is not clear to me.
Nick
[email protected]
Quang Nguyen
Thanks Nick and Martin. Actually, the question is a bit trickier than
"append" can handle. The structure of data 1 and 2 are different,
thus, the append would result in all missing values for the mitsmatch
variables. Thus,
append using data2
will result in all missing values for x, y, z in the combined data set.
Actually, I would like to have the combined data as follows:
Combined data:
id x y z v
1 4 a 7 missing
1 4 b 8 missing
1 4 c 9 missing
1 4 missing missing 4
1 4 missing missing 2
Given:
Data 1
id v
1 4
1 2
2 6
2 7
-------------
Data 2:
id x y z
1 4 a 7
1 4 b 8
1 4 c 9
2 6 a 7
2 6 b 8
2 6 c 9
On Mon, Apr 13, 2009 at 3:43 AM, Quang Nguyen <[email protected]> wrote:
> Dear All:
>
> Suppose I have the 2 following data set1:
>
> Data 1
> id v
> 1 4
> 1 2
> 2 6
> 2 7
> -------------
>
> Data 2:
> id x y z
> 1 4 a 7
> 1 4 b 8
> 1 4 c 9
> 2 6 a 7
> 2 6 b 8
> 2 6 c 9
>
>
> Note that _x_ is a fixed effect in data 2 as well as the combined data
> set. Given that, do you know how I can append data 1 to data 2 so
> that the combined data set will have infor from both data 1 and 2 and
> some missing values due to mismatch between v and (y,z). Specifically,
> the combined data for the first observation looks like the following:
>
> Combined data:
>
> id x y z v
> 1 4 a 7 mis
> 1 4 b 8 mis
> 1 4 c 9 mis
> 1 4 mis mis 4
> 1 4 mis mis 2
> ......
*
* 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/
