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]

Re: st: Fw: Exporting variable labels to an excel worksheet


From   Amir Kasaeian <amir_kasaeian@yahoo.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Fw: Exporting variable labels to an excel worksheet
Date   Thu, 8 Nov 2012 08:14:25 -0800 (PST)

Thank you all,
But this is just works on Stata 12 but what about Stata 11?
Could you please let me know the way in Stata 11.
Thank you very much.

Bests,
Amir

________________________________
From: Rebecca Pope <rebecca.a.pope@gmail.com>
To: statalist@hsphsun2.harvard.edu 
Sent: Thursday, 8 November 2012, 17:44
Subject: Re: st: Fw: Exporting variable labels to an excel worksheet

Yes, you can. If you see -help export excel-, you'll find that
exporting to Excel gives you the following option
"firstrow(variables|varlabels)" which lets you write the variable
labels in place of the variable names to the first line of the
spreadsheet.

Hope this helps.
Rebecca



On Thu, Nov 8, 2012 at 8:05 AM, Amir Kasaeian <amir_kasaeian@yahoo.com> wrote:
>
> Dear Statalist,
>
>
> Could you please let me know how can I export variable labels of a Stata data file to an excel worksheet?
> Thanks your help in advance.
>
> best,
> Amir
>
> *
> *   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/
*
*   For searches and help try:
*  http://www.stata.com/help.cgi?searchhttp://www.stata.com/support/faqs/resources/statalist-faq/http://www.ats.ucla.edu/stat/stata/ ;

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