cd "C:\2_Data\News Analytics\14. Equity Data-Web Edition"
local filelist: dir . files "*.dta"
foreach file of local filelist {
bysort source country_code: gen howmany=_N
sort source country_code
quietly by source country_code: gen dup =cond(_N==1,0,_n)
drop if dup >1
drop dup
save "C:\2_Data\Essay_2_Sample\sourcenation\2007.dta", replace
}