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 <[email protected]>
To
[email protected]
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
> [email protected]
>
>
> On 2 June 2013 19:03, Paul Byatta <[email protected]> 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/