Back to Browse

Export results to Excel® using Stata

17.7K views
Sep 24, 2024
5:42

Learn how to use Stata's *putexcel* commands to export results to an Excel workbook. The commands used in this video are below: sysuse auto putexcel set "auto", sheet(descriptives) replace dtable mpg price weight, by(foreign) pwcorr mpg price weight return list putexcel F1 = ( today() ), asdatenum nformat("d-mmm-yy") putexcel A1 = collect, name(DTable) putexcel B8 = matrix(r(C)), names nformat("####.00") putexcel A8 = ("Correlation:"), bold putexcel set "auto", sheet(regression) modify regress mpg c.weight##foreign putexcel A1 = etable margins foreign, at(weight=(2000 3000 4000)) plot graph export interaction.png, height(1000) putexcel A12 = image(interaction.png) putexcel save https://www.stata.com

Download

1 formats

Video Formats

360pmp48.4 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Export results to Excel® using Stata | NatokHD