IDEAS home Printed from https://ideas.repec.org/p/boc/usug16/05.html
   My bibliography  Save this paper

Creating summary tables using the sumtable command

Author

Listed:
  • Lauren Scott

    (Clinical Trials and Evaluation Unit, Bristol)

  • Chris Rogers

    (Clinical Trials and Evaluation Unit, Bristol)

Abstract

In many fields of statistics, summary tables are used to describe characteristics within a study population. Moreover, such tables are often used to compare characteristics of two or more groups, for example, treatment groups in a clinical trial or different cohorts in an observational study. This talk introduces the sumtable command, a user-written command that can be used to produce such summary tables, allowing for different summary measures within one table. Summary measures available include means and standard deviations, medians and interquartile ranges, and numbers and percentages. The command removes any manual aspect of creating these tables (for example, copying and pasting from the Stata output window) and therefore eliminates transposition errors. It also makes creating a summary table quick and easy and is especially useful if data are updated and tables subsequently need to change. The end result is an Excel spreadsheet that can be easily manipulated for reports or other documents. Although this command was written in the context of medical statistics, it would be equally useful in many other settings.

Suggested Citation

  • Lauren Scott & Chris Rogers, 2016. "Creating summary tables using the sumtable command," United Kingdom Stata Users' Group Meetings 2016 05, Stata Users Group.
    • Handle: RePEc:boc:usug16:05
    as

    Download full text from publisher

    File URL: http://repec.org/usug2016/crowther_uksug16.pdf
    File Function: presentation slides
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Sally R. Hinchliffe & David A. Scott & Paul C. Lambert, 2013. "Flexible parametric illness-death models," Stata Journal, StataCorp LP, vol. 13(4), pages 759-775, December.
    2. Jackson, Christopher, 2011. "Multi-State Models for Panel Data: The msm Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 38(i08).
    3. Asaria, Miqdad & Walker, Simon & Palmer, Stephen & Gale, Chris P & Shah, Anoop D & Abrams, Keith R & Crowther, Michael & Manca, Andrea & Timmis, Adam & Hemingway, Harry & Sculpher, Mark, 2016. "Using electronic health records to predict costs and outcomes in stable coronary artery disease," LSE Research Online Documents on Economics 101257, London School of Economics and Political Science, LSE Library.
    4. Jackson, Christopher, 2016. "flexsurv: A Platform for Parametric Survival Modeling in R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 70(i08).
    5. Andrew C. Titman, 2011. "Flexible Nonhomogeneous Markov Models for Panel Observed Data," Biometrics, The International Biometric Society, vol. 67(3), pages 780-787, September.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Michael Crowther & Paul Lambert, 2016. "Multistate survival analysis in Stata," United Kingdom Stata Users' Group Meetings 2016 02, Stata Users Group.
    2. Machado, Robson J.M. & van den Hout, Ardo & Marra, Giampiero, 2021. "Penalised maximum likelihood estimation in multi-state models for interval-censored data," Computational Statistics & Data Analysis, Elsevier, vol. 153(C).
    3. Sharples, Linda D., 2018. "The role of statistics in the era of big data: Electronic health records for healthcare research," Statistics & Probability Letters, Elsevier, vol. 136(C), pages 105-110.
    4. Francesco Grossetti & Francesca Ieva & Anna Maria Paganoni, 2018. "A multi-state approach to patients affected by chronic heart failure," Health Care Management Science, Springer, vol. 21(2), pages 281-291, June.
    5. Qiu, Qinjing & Kawai, Reiichiro, 2022. "A decoupling principle for Markov-modulated chains," Statistics & Probability Letters, Elsevier, vol. 182(C).
    6. Jackson, Christopher, 2016. "flexsurv: A Platform for Parametric Survival Modeling in R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 70(i08).
    7. Vernon T. Farewell & Li Su & Christopher Jackson, 2019. "Partially hidden multi-state modelling of a prolonged disease state defined by a composite outcome," Lifetime Data Analysis: An International Journal Devoted to Statistical Methods and Applications for Time-to-Event Data, Springer, vol. 25(4), pages 696-711, October.
    8. Gaffney, Edward & McCann, Fergal, 2019. "The cyclicality in SICR: mortgage modelling under IFRS 9," ESRB Working Paper Series 92, European Systemic Risk Board.
    9. Elizabeth G Bond & Lusine Abrahamyan & Mohammad K A Khan & Andrea Gershon & Murray Krahn & Ping Li & Rajibul Mian & Nicholas Mitsakakis & Mohsen Sadatsafavi & Teresa To & Petros Pechlivanoglou & for t, 2020. "Understanding resource utilization and mortality in COPD to support policy making: A microsimulation study," PLOS ONE, Public Library of Science, vol. 15(8), pages 1-16, August.
    10. Biagini, Francesca & Groll, Andreas & Widenmann, Jan, 2013. "Intensity-based premium evaluation for unemployment insurance products," Insurance: Mathematics and Economics, Elsevier, vol. 53(1), pages 302-316.
    11. Touraine, Célia & Gerds, Thomas A. & Joly, Pierre, 2017. "SmoothHazard: An R Package for Fitting Regression Models to Interval-Censored Observations of Illness-Death Models," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 79(i07).
    12. Alex Bottle & Chiara Maria Ventura & Kumar Dharmarajan & Paul Aylin & Francesca Ieva & Anna Maria Paganoni, 2018. "Regional variation in hospitalisation and mortality in heart failure: comparison of England and Lombardy using multistate modelling," Health Care Management Science, Springer, vol. 21(2), pages 292-304, June.
    13. Wildhaber, Mark L. & Albers, Janice L. & Green, Nicholas S. & Moran, Edward H., 2017. "A fully-stochasticized, age-structured population model for population viability analysis of fish: Lower Missouri River endangered pallid sturgeon example," Ecological Modelling, Elsevier, vol. 359(C), pages 434-448.
    14. Alexandra Grand & Regina Dittrich & Brian Francis, 2015. "Markov models of dependence in longitudinal paired comparisons: an application to course design," AStA Advances in Statistical Analysis, Springer;German Statistical Society, vol. 99(2), pages 237-257, April.
    15. Budhi Surya, 2021. "A new class of conditional Markov jump processes with regime switching and path dependence: properties and maximum likelihood estimation," Papers 2107.07026, arXiv.org.
    16. Suvra Pal & Hongbo Yu & Zachary D. Loucks & Ian M. Harris, 2020. "Illustration of the Flexibility of Generalized Gamma Distribution in Modeling Right Censored Survival Data: Analysis of Two Cancer Datasets," Annals of Data Science, Springer, vol. 7(1), pages 77-90, March.
    17. Linda Möstel & Marius Pfeuffer & Matthias Fischer, 2020. "Statistical inference for Markov chains with applications to credit risk," Computational Statistics, Springer, vol. 35(4), pages 1659-1684, December.
    18. Alejandra Marroig, 2023. "Transitions across states with and without difficulties in performing activities of daily living and death: a longitudinal comparison of ten European countries," European Journal of Ageing, Springer, vol. 20(1), pages 1-12, December.
    19. Emily B Dennis & Byron J T Morgan & Stephen N Freeman & Martin S Ridout & Tom M Brereton & Richard Fox & Gary D Powney & David B Roy, 2017. "Efficient occupancy model-fitting for extensive citizen-science data," PLOS ONE, Public Library of Science, vol. 12(3), pages 1-17, March.
    20. Tsiropoulos, Vasilis, 2018. "A Vulnerability Analysis for Mortgaged Irish Households," Financial Stability Notes 02-18, Central Bank of Ireland.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:boc:usug16:05. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Christopher F Baum (email available below). General contact details of provider: https://edirc.repec.org/data/stataea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.