To re-create the table in Excel, we need to export the matrix r(C) with the matrix row and column names. In your Stata Command window, type . putexcel A1=matrix(r(C), names) using corr To export the matrix row and column names, we used the names option after we specifed the ...
file Table1.xlsx saved . putexcel C3 = "Gray75", fpattern(gray75) file Table1.xlsx saved . putexcel D4 = "Solid Red", fpattern(solid, red) file Table1.xlsx saved 案例9:合并单元格 想通过合并单元格来创建一个需要几列的标题。 putexcel set Table1.xlsx, sheet(Sheet1) replace Note: fi...
使用export命令就可以了 export excel using xxxx.xlsx
eststo: xi: reg y x control3 control2 i.control1, r cl(control) //设置表格相关格式,例如显著性水平的显示 esttab using table9.csv, b(%12.3fc) label se ar2 nogap star(* 0.10 ** 0.05 *** 0.01) keep(x control1 control2) order(x control1 control2) replace...
Stata结果输出：Excel结果表变身LaTeX表格 baselinetable命令：论文基本统计量表格输出到Excel和Word pwcorr_...
export excel 'c:\tables\means.xlsx', firstrow(variables) Here is an example of how to write a program to build a more complex table with many rows. putexcel(这个非常实用) New in Stata 13 is the command putexcel. It reads the parameter estimates described above and writes them directly ...
如果你哪天需要的是excel檔,把test.rtf改成test.csv就行了。 ←Previous Post Next Post→ 76 thoughts on “Stata: 輸出regression table到word和excel” Recent Comments Yunaon2023年徵文第一名:豈曰無衣,與子同袍 by 金旻 Wordviceon論文寫作索引 ...
我甚至会向你们展示如何创建自己版本的ExcelTable。今天我们将重点讨论设计表达式和单元格的格式。 在Stata14.2版本中,我们在putexcel命令方面做了一些改进,所以你可以升级Stata版本,这样就可以运行下面这些案例。你可能还记得KevinCrow曾经写过的2篇关于putexcel命令的博文,博文名称是Export tables to Excel和Retaining an ...
export excel "c:\tables\means.xlsx", firstrow(variables) Here is an example of how to write a program to build a more complex table with many rows. putexcel(这个非常实用) New in Stata 13 is the command putexcel. It reads the parameter estimates described above and writes them directly ...
案例1:设置目标文件我们先给Excel表格设置目标文件和工作表 .putexcelsetTable1.xlsx,sheet(Sheet1)replace Note:filewillbereplacedwhenthefirstputexcelcommandisissued 在运行任何putexcel命令前要先创建一个目标文件,如果你没有用putexcelset命令指定一个不同的表格,那么所有后续的putexcel命令都将写在文件名为Table1....