import excel "D:\Stata13\gsyh.xls", sheet("TRD_Dalyr") firstrow
.
. save r1,replace
file r1.dta saved
.
.
.
. sort Trddt
.
. save,replace
file r1.dta saved
.
. merge m:1 Trddt using mr1, uniqusing
option uniqusing not allowed
r(198);
.
. drop if _merge!=3
_merge not found
r(111);
.
. save merg_market,replace
file merg_market.dta saved
.
. drop _merge
variable _merge not found
r(111);
.
. export excel using "D:\Stata13\scsyl.xlsx", firstrow(variables) replace
file D:\Stata13\scsyl.xlsx saved
.
.
.
. gen r11=r1-0.05
(2 missing values generated)
.
. gen mr11=mr1-0.05
mr1 not found
r(111);
.
. reg r11 mr11,nocon
variable mr11 not found
r(111);