st: Export Excel – multiple worksheets

["Kathrin Jacobs" <jacobs.1@gmx.net>]

Hi,

I want to use the export excel feature and I am unsure about the syntax. I would like to export variables into multiple Excel worksheets. 

In the end, GDP from 2000 to 2010 for certain industries should be in the first worksheet, employment from 2000 to 2010 for certain industries should be in the second worksheet, etc.

My data looks like this in Stata:
Industry    GDP_2000 … GDP_2010   EMP_2000 … EMP_2010 
a             1458      1589       5777      6458      
b             1871      1751       2458      2587      
c             1775      1879       3845      4148      

I need the data look like this in Excel:
Worksheet 1:
Industry    GDP_2000 … GDP_2010    
a             1458      1589            
b             1871      1751            
c             1775      1879       
               
Worksheet 2:
Industry   EMP_2000 … EMP_2010 
a             5777      6458      
b             2458      2587      
c             3845      4148 

Any ideas?
Many thanks,
Kathrin
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/