- * Example generated by -dataex-. For more info, type help dataex
- clear
- input byte a float(b c d)
- 1 2 3 2
- 1 2 3 2
- 1 2 3 2
- 1 2 3 2
- 1 3 3 2
- 1 3 4 5
- 2 3 3 3
- 2 3 5 4
- 2 4 5 4
- 2 4 5 3
- 3 6 6 2
- 3 7 6 5
- 4 7 6 6
- 3 6 7 6
- end
- preserve
- gen 模型="."
- gen R平方=.
- local i=1
- foreach var of varlist b-d{
- reg a `var'
- replace R平方=e(r2) if _n==`i'
- replace 模型="回归1:`e(cmdline)'" if _n==`i'
- local ++i
- }
- replace 模型=subinstr(模型,"ress","",1)
- format R平方 %5.4f
- keep 模型 R平方
- keep if _n <= 3
- list,noobs
- +------------------------+
- | 模型 R平方 |
- |------------------------|
- | 回归1:reg a b 0.8840 |
- | 回归1:reg a c 0.7611 |
- | 回归1:reg a d 0.4438 |
- +------------------------+
- export excel result.xlsx,first(var) replace
- restore