新手第一次发帖求助!求指导!
merge了三个表,用countyid关联,第一个表有2800行数据,第二个表有87行,merge后只有47个匹配上了,怎么把没有匹配的删掉啊? merge m:1 countyid using "C:\Users\Administrator\Desktop\disease1.dta", generate (merge1)
Result # of obs.
-----------------------------------------
not matched 2,862
from master 2,822 (merge1==1)
from using 40 (merge1==2)
matched 47 (merge1==3)
-----------------------------------------
第三个表跟第二个表示完美关联的,所以match上了87个。
merge m:1 countyid using "C:\Users\Administrator\Desktop\disease2.dta", generate (merge2)
Result # of obs.
-----------------------------------------
not matched 2,822
from master 2,822 (merge2==1)
from using 0 (merge2==2)
matched 87 (merge2==3)
-----------------------------------------
先谢过各位大神了!