St. James Ballroom
Creating 88 Dynamic Tables with Stata's Putexcel Function (303881)
*Jason Andrew Benedict, OSU Center for Biostatistics
Keywords: Stata, Putexcel, Dynamic, Mata, Table
The Center for Biostatistics at OSU was tasked with creating a table summarizing health department information for every county in Ohio. Our collaborator for the project was originally planning to hire a student to input all of the information. As this likely would have resulted in multiple data entry errors, we searched for a better solution.
Stata's Putexcel function is an incredibly powerful tool that -- combined with loops, macros, and mata -- can produce dynamic tables for any need. We used a combination of all of these functions to create the exact tables our collaborator was hoping to present. As a bonus, we expect to receive this project every year, and what would have been hours of work will now take only a few minutes. This poster covers some of the programming statements that enabled us to complete this project.