|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: question about merging two data sets with non-uniqueidentifiers.
|
From |
"Roy,Suryadipta" <[email protected]> |
|
To |
[email protected] |
|
Subject |
Re: st: question about merging two data sets with non-uniqueidentifiers. |
|
Date |
Sat, 07 Apr 2007 09:42:26 -0500 |
Yan,
This might work:
use B
sort stock
use A
sort stock
joinby stock using B, unmatched(master)
Best,
Suryadipta.
On Sat, 7 Apr 2007 05:47:26 -0700 (PDT)
Yan Zhang <[email protected]> wrote:
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/
*
* 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/
