Hi, could anybody tell me how to solve the match
problem about merging two data sets both of which have
non-unique identifiers.
For example, if DataSet A has:
stock date
11 aa
11 bb
11 cc
33 AA
and dataset B has
stock id
11 wen
11 fra
After using "merge stock using "......" ", I got the
following:
stock id date _merge
11 wen aa 3
11 fra bb 3
11 fra cc 3
33 AA 1
How could I get the results as follows as desired?
What I want is as follows:
stock id date _merge
11 wen aa 3
11 wen bb 3
11 wen cc 3
11 fra aa 3
11 fra bb 3
11 fra cc 3
33 AA 1
Thanks a lot!
____________________________________________________________________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
*
* 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/
