About Us | Research | Education | Clinical Practice | Your Career | Health Policy | Publications | Meetings

User's Guide: Other General Tips

The following 10 tips developed by SGIM members John Ayanian and Ellen McCarthy succinctly summarize key issues to consider when planning and executing a secondary data analysis:

  1. Start with a clear research question and hypothesis
  2. Get to know your data source:
    • Why does the database exist?
    • Who reports the data?
    • What are the incentives for accurate reporting?
    • How are the data audited, if at all?
    • Can you link the data to other large databases?
  3. Get good documentation of the cohort, variables, and data layout, then read the fine print
  4. Consult or collaborate with researchers who have used the database
  5. Line up computing resources before data arrive
  6. Allow time to receive data if not publicly available
  7. Learn SAS, Stata, or other statistical software so you can analyze data yourself
  8. Assess outliers & missing data with plots or frequency tables
  9. Consult or collaborate with a statistician on your analysis plan, especially for complex surveys with sampling weights
  10. Use clinical intuition to interpret results and consult experts as needed

In addition, the following articles provide useful general advice on planning and conducting secondary data analysis.

Observational research databases in renal disease.
Shlipak M, Stehman-Breen C.
J Am Soc Nephrol. 2005 Dec;16(12):3477-84.

Using secondary data sources for pharmacoepidemiology and outcomes research.
Harpe SE.
Pharmacotherapy. 2009 Feb;29(2):138-53.

 

  • Which comes first – the dataset or the research question?
  • Opportunities, pitfalls, and common mistakes in working with secondary data
  • Issues in data coding and validation
  • Statistical issues in working with secondary data
  • IRB issues
  • Other general tips
  • Resources for secondary data analysis of specific topics and datasets

  • © Society of General Internal Medicine
    2501 M Street NW Suite 575 Washington, DC 20037
    800-822-3060 or 202-887-5150



    Text last updated on 04/02/2009 at 02:27 PM.


    Members Login Here

    Registation Open Now: Academic Hospitalist Academy
    Jul 21 - Get the skills for success!
    HRSA: $168 Million to Train 500 New Primary Care Physicians
    Jun 25 - Applications for funding are due by Monday, July 19, 2010.
    Health Service Corps Expands, Offers Loan Repayment Awards
    Jun 25 - Primary care professionals eligible to receive up to $145,000 in loan repayment.
    Senate Passes SGR Fix
    Jun 18 - Legislation provides 2.2 percent Medicare physician payment update.
    Fatal Medication Errors Spike in July
    Jun 07 - A new article in the Journal of General Internal Medicine shows a possible link in fatal medication errors and new medical residents.
    Message from SGIM President
    May 28 - SGIM Council makes a decision on 2011 Annual Meeting planned for Phoenix Arizona
    A New Home for SGIM: What a Capital Idea!
    May 27 - Support the SGIM Capital Campaign