stata - 在 Excel 中导出表格
问题描述
考虑以下玩具示例:
sysuse auto, clear
tab foreign, sum(price)
| Summary of Price
Car type | Mean Std. Dev. Freq.
------------+------------------------------------
Domestic | 6,072.423 3,097.104 52
Foreign | 6,384.682 2,621.915 22
------------+------------------------------------
Total | 6,165.257 2,949.496 74
如何将结果保存在 Excel 文件中?
解决方案
使用community-contributed command esttab
,以下对我有用:
sysuse auto, clear
egen m_total = mean(price)
egen s_total = sd(price)
scalar mtotal = m_total
scalar stotal = s_total
scalar N = _N
collapse (mean) Mean=price (sd) StdDev=price (count) Freq = price, by(foreign)
set obs 3
replace Mean = mtotal in 3
replace StdDev = stotal in 3
replace Freq = N in 3
mkmat Mean StdDev Freq, matrix(A)
esttab matrix(A) using myfilename.xls, varlabels(r1 Domestic r2 Foreign r3 Total) ///
title(" Summary of Price") mlabels(none)
Summary of Price
---------------------------------------------------
Mean StdDev Freq
---------------------------------------------------
Domestic 6072.423 3097.104 52
Foreign 6384.682 2621.915 22
Total 6165.257 2949.496 74
---------------------------------------------------
推荐阅读
- xpath - 如何获取特定的 xpath 标记值
- python - TicTacToe Tkinter GUI 不断崩溃
- scala - json4s第一次序列化耗时异常长
- react-native-paper - 如何向 React Native Paper Paragraph 添加超链接或邮件链接?
- html - 星级评分组件在悬停时填充所有以前的星星
- android - AdMob:测试广告只展示一次,不再加载
- javascript - 无法读取 null 的属性“addEventListener”,有没有更好的方法来防止这种情况
- graphql - 如何使用带有特定参数的 Nexus 的 Prisma 插件 crud
- list - 如何在不手动复制和粘贴的情况下循环遍历 python 生成的列表?
- python - 在 Python 中查询输入是 int 还是 str