Dear statalisters,
here is my simple but nonetheless tricky problem to merge two data sets:
My master data set has 62 observations and 312 variables.
I want to merge it with a using data set containing 16 variables for the same! 62 observations, some are string and some numerical variables. I could even include a code variable from 1 to 62 that is identical in both data sets.
When I use "append", stata generates 62 new observations (creating a total of 124 observations) with missing values for all except the 16 new variables (and missings for the 16 new variables in observations 1 to 62), when I use "merge" , stata tells me my master data was not sorted, even though it is, or that it doesn't find the first variable (of the using data set).
I would be grateful for hints to solve this problem!
Dietrich.
--�
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
��Dietrich�Dr�ner
��Schneckenburgstr.�24
��D�-�78467�Konstanz
��Tel.�(+49)�-�7531�-�698003
��Fax��(+49)�-�1212�-�522970813
��Mob.(Inland):�(+49)�-�177�-�6334099
��Mob.(Ausland):(+49)�-�162�-�7679952
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*
* 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/
