I'm interested in doing a DEA using panel data of 34 provinces and 4 years. After running the dea command, I've encountered an error:
new variables cannot be uniquely named or already defined
r(110);
How can I resolve it? Please let me know if I have missed out some context. Thanks!
Here are the codes I used before running dea:
Below is the first few lines of the result
new variables cannot be uniquely named or already defined
r(110);
How can I resolve it? Please let me know if I have missed out some context. Thanks!
Here are the codes I used before running dea:
Code:
log using dea_comparison_log.log, text replace
import excel "C:\Users\Amara\Downloads\DEA Skripsi - Dropped Missing Values.xlsx", sheet("Sheet1") firstrow
drop if missing(GRDP_Growth) | missing(Capital_EXP) | missing(Current_EXP)
gen dmu = id
dea Capital_EXP Current_EXP dmu = GRDP_Growth, rts(crs) saving(crs_result, replace)
Below is the first few lines of the result
Code:
name: dealog
log: C:\Users\Amara\Downloads\Data Management 2022\Stata 15.0 x64\dea.log
log type: text
opened on: 5 Jun 2024, 19:46:56
options: RTS(CRS) ORT(IN) STAGE(2)
CRS-INPUT Oriented DEA Efficiency Results
ref: ref: ref: ref: ref: ref: ref: ref: ref:
rank theta 1 1 1 1 2 2 2 2 3
dmu:1 . . . . . . . . . . .
dmu:1 103 1 . 1 . . 0 . . . .
dmu:1 111 1 . . . . . . . . .
dmu:1 21 8.35905 . 2.1393 . . . . . . .
