Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Working with aggregated data / exporting results to excel


From   "Puddicombe, David" <David.Puddicombe@bccdc.ca>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: Working with aggregated data / exporting results to excel
Date   Tue, 14 Feb 2012 11:47:37 -0800

Hi,
 
I am working with a dataset that has summary statistics for health facilities.  Each facility is within a health authority.  I would like to produce and export summary statistics to excel.
 
For example, the tabout command below creates a table that I would like to export to excel which has the number of staff immunized, the total number of staff, and I would like to add the percentage immunized as a column (but could do this in excel if necessary).
 
tabstat hcwai hcwa, by(ha) stat(sum) format(%9.0f)

Summary statistics: sum
  by categories of: ha (Health Authority)
 
    ha |   hcwaimm      hcwa
-------+--------------------
   IHA |      4490     10132
   FHA |      5173     16984
  VCHA |      5644     12173
  VIHA |      3941     10021
   NHA |      1832      4396
  PHSA |      2015      4389
-------+--------------------
 Total |     23095     58095
----------------------------
 
ha = health authority
hcwaimm = immunized
hcwa = total health care workers
 
Any help with this and general advice or suggested resources for working with aggregated data would be greatly appreciated.
 
Thanks! 
 
David Puddicombe
BC Centre for Disease Control 

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index