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: outsheet and variable labels


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: outsheet and variable labels
Date   Mon, 3 Jun 2013 00:15:38 +0100

Richard is quite correct.

(I have never used -export excel- that I can remember. It was
introduced in Stata 12.)

Nick
njcoxstata@gmail.com


On 3 June 2013 00:08, Richard Goldstein <richgold@ix.netcom.com> wrote:
> I am confused by your use of "excel/csv"; this is relevant because if
> you actually want to end up with an excel spreadsheet you should use
> "export excel" which offers an option to display variable labels rather
> than variable names
>
> Rich
>
> On 6/2/13 2:12 PM, Nick Cox wrote:
>> I think the short answer is No. It's programmable in so far as you
>> could write a program to do it.
>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 2 June 2013 19:03, Paul Byatta <paulbyatta@gmail.com> wrote:
>>> Hi All,
>>>
>>> I was wondering whether there is a way of displaying variable labels
>>> instead of variable names when I outsheet results to an excel/csv
>>> document.
>>>
>>> I understand the command below adds a variable label on a variable name.
>>>
>>> label variable vlg_id "Village ID"
>>>
>>> But how do I make "Village ID" appear on my excel/csv instead of "vlg_id"
>>>
>>> My ousheet command looks like this
>>>
>>> outsheet using VillageID.csv, comma replace
>>>
>>> Thanks
>>> Paul
> *
> *   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?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