Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

Re: st: outsheet and variable labels


From   Richard Goldstein <richgold@ix.netcom.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: outsheet and variable labels
Date   Sun, 02 Jun 2013 19:08:17 -0400

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/


© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index