Hi,
So I merged two datasets together and some data from the master file was not able to merge (_new_merge_==1). I merged on providerid and year through the following code:
use finalnewconversion.dta, clear
merge m:1 providerid year using qualitymeasures.dta, gen(_new_merge_)
Result # of obs.
-----------------------------------------
not matched 22,376
from master 464 (_new_merge_==1)
from using 21,912 (_new_merge_==2)
matched 7,816 (_new_merge_==3)
-----------------------------------------
drop if _new_merge_==2
sort providerid oldproviderid year
order providerid oldproviderid n year status conversion
save finaldataset.dta, replace
However, the issue here is that qualitymeasures.dta lists both oldproviderid's and providerid's together as "providerid" but finalnewconversion.dta will seperate the two. Therefore, I was thinking of generating an oldproviderid variable for qualitymeasure.dta and try merging the two files like that but am having trouble creating the code. Any recommendations would be helpful on how to approach this.
FYI: providerid represents critical access hospitals and have a 1300-1399 ending in their id
Finalnewconversion.dta or "fullcahdata"
Qualitymeasures.dta
Visual aid
So I merged two datasets together and some data from the master file was not able to merge (_new_merge_==1). I merged on providerid and year through the following code:
use finalnewconversion.dta, clear
merge m:1 providerid year using qualitymeasures.dta, gen(_new_merge_)
Result # of obs.
-----------------------------------------
not matched 22,376
from master 464 (_new_merge_==1)
from using 21,912 (_new_merge_==2)
matched 7,816 (_new_merge_==3)
-----------------------------------------
drop if _new_merge_==2
sort providerid oldproviderid year
order providerid oldproviderid n year status conversion
save finaldataset.dta, replace
However, the issue here is that qualitymeasures.dta lists both oldproviderid's and providerid's together as "providerid" but finalnewconversion.dta will seperate the two. Therefore, I was thinking of generating an oldproviderid variable for qualitymeasure.dta and try merging the two files like that but am having trouble creating the code. Any recommendations would be helpful on how to approach this.
FYI: providerid represents critical access hospitals and have a 1300-1399 ending in their id
Finalnewconversion.dta or "fullcahdata"
Qualitymeasures.dta
Visual aid
Comment