Categories: Programming Tags: ExcelexportoutputputexceltablesWord. Categories: Programming Tags: Excelputexcel.Ĭreating Excel tables with putexcel, part 2: Macro, picture, matrix, and formula expressions 24 January Chuck Huber, Associate Director of Statistical Outreach 6 comments. Creating Excel tables with putexcel part 3: Writing custom reports for arbitrary variables 6 April Chuck Huber, Associate Director of Statistical Outreach 3 comments. There is a new command in Stata 13, putexcelthat allows you to easily export matrices, expressions, and stored results to an Excel file.
Stata 13 putexcel update#
Update 07 June See Export tabulation results to Excel-Update for new features that have been added since this original blog.
![stata 13 putexcel stata 13 putexcel](https://www.stata.com/stata-news/news29-1/export-tables-to-excel/i/results2.png)
After the entry was posted, a few users pointed out two features they wanted added to putexcel. So I wrote a program called ExcelTable for my own use Read more…. Before we begin the examples, Read more…. These are important steps toward our goal of automating the creation of reports in Excel.
Stata 13 putexcel how to#
I will even show you how to write formulas to Excel to create calculated cells. Today, I want to show you how to write more complex expressions such as macros, graphs, and matrices. In my last postI showed how to use putexcel to write simple expressions to Microsoft Excel and format the resulting text and cells. This is another important step toward our goal of automating the creation of reports in Excel. You could extend this idea by creating a do-file for each report and passing the variable names into the do-files. This will allow me to create the same report for arbitrary variables by simply assigning new variable names to the macros. I am also going to pass the variable names into my programs using local macros. But you could modify the examples below to include column percentages, percentiles, standard errors, confidence intervals or any statistic.
![stata 13 putexcel stata 13 putexcel](https://methods.sagepub.com/images/virtual/putexcel-loops-in-wtms-2009-stata/10.4135_9781526499493-fig6.jpg)
I am going to create tables that combine cell counts with row percentages, and means with standard deviations. Today I want to show you how to create custom reports for arbitrary variables. In my last postI demonstrated how to use putexcel to recreate common Stata output in Microsoft Excel.