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 at the end of May, and its replacement, statalist.org is already up and running.


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

st: Re: st: Re: st: Export Excel – multiple worksheets


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: st: Re: st: Export Excel – multiple worksheets
Date   Tue, 23 Oct 2012 09:33:49 +0100

Kathrin is clearly referring to the -export excel- command added in Stata 12.

The help makes it explicit that you can specify variables you want
exported and that there is a -sheet()- option, so nothing exotic seems
needed here, and there is no need to install a user-written command.

People on Stata < 12 can see

http://www.stata.com/help.cgi?export_excel

for what is concerned.

Nick

On Tue, Oct 23, 2012 at 9:22 AM, Muhammad Anees <anees@aneconomist.com> wrote:

> Read -help xml_tab- whereby -xml_tab is a user written command by
> Zurab Sajaia and Michael Lokshin and available from SSC - ssc install
> xml_tab - which has an option  ----sheet(name [, sh_opts])---    which
> names a worksheet where the table is outputted. I hope this would be
> of some help to your case.

On Tue, Oct 23, 2012 at 1:07 PM, Kathrin Jacobs <jacobs.1@gmx.net> wrote:

>> 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
>>

*
*   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/


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