<>
What is the difference to the result of my code? Add a
*************
bys id: replace x=x[1]
*************
to make it complete...
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Quang Nguyen
Gesendet: Montag, 13. April 2009 16:21
An: [email protected]
Betreff: Re: st: How to append these two data sets
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
> ......
>
>
> Many thanks!
>
>
>
> --
> "My father gave me the greatest gift anyone could give another person,
> he believed in me." - Jim Valvano
>
>
>
> --
> "My father gave me the greatest gift anyone could give another person,
> he believed in me." - Jim Valvano
>
> *
> * 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/
>
--
"My father gave me the greatest gift anyone could give another person,
he believed in me." - Jim Valvano
*
* 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/
