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 on April 23, 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   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index