Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: merging dataset


From   "Rima Chakravarty" <[email protected]>
To   <[email protected]>
Subject   st: merging dataset
Date   Fri, 31 Aug 2007 09:11:10 -0400

Wondering if anybody can help me with this. I want to merge two dataset (AA and BB) based on ID. 

Dataset AA
ID    Var 1   Var 2   Var 3 
12     785     .         748
45     74       2        63
74     789     0        7485


Dataset BB
ID    Var 1   Var 2    Var 3
12      .         45        748
94      41       78        74
74      789     0          7485

I have used the merge command but the problem with that is that the dataset BB has missing value for ID =12 (Var 1). I want to replace the non-missing value in the merged dataset with the missing value and I think the merge command do not do that. Everything else did correctly.

Any suggestion !

Rima


_______________________________________________________________

Rima Chakravarty
Economist
Policy Analysis and Statistics Division
NC Department of Revenue
Phone: 919.733.7738



------------------------------------------------------------------------------ 
E-Mail correspondence to and from this sender may be subject to the
North Carolina Public Records Law, and may be disclosed to third parties.
------------------------------------------------------------------------------

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index