RE: st: output variables and labels to excel

[Caroline Wilson <wilson_cj@hotmail.com>]

Hmm, I get an error when I use export - perhaps because I am using Stata 11?

. export excel name varlab using varlabs
unrecognized command:  export
r(199);

If there isn't a way to use export in Stata 11 - David, would there be a way to modify your code to also include value labels? For example, something like:

Variable name         Variable label          Value label
gender                Patient gender          1;"Female";0;"Male"
Race                  Patient race            1; "White"; 2 "Black"; 3 "Other"
etc.


Many thanks to everyone who replied for all the great tips! 
Caroline

----------------------------------------
> Subject: RE: st: output variables and labels to excel
> Date: Mon, 19 Aug 2013 15:06:32 -0400
> From: dradwin@rti.org
> To: statalist@hsphsun2.harvard.edu
>
> Agreed. Great tip! Thank you.
>
> David
> --
> David Radwin
> Senior Research Associate
> Education Studies Division
> RTI International
> 2150 Shattuck Ave., Suite 800
> Berkeley, CA 94704
> Phone: 510-665-8274
>
> www.rti.org
>
>
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>> statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
>> Sent: Monday, August 19, 2013 12:05 PM
>> To: statalist@hsphsun2.harvard.edu
>> Subject: Re: st: output variables and labels to excel
>>
>> Good point. Thanks,
>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 19 August 2013 19:58, Robert Picard <picard@netbox.com> wrote:
>>> nope, this is a relatively unknown feature of -describe-. The
>>> -replace- option creates a dataset with the output of -describe-.
>>>
>>> On Mon, Aug 19, 2013 at 2:56 PM, Nick Cox <njcoxstata@gmail.com>
> wrote:
>>>> But you must create -name- and -varlab- yourself first, right?
>>>> Nick
>>>> njcoxstata@gmail.com
>>>>
>>>>
>>>> On 19 August 2013 19:48, Robert Picard <picard@netbox.com> wrote:
>>>>> It can't get any easier than...
>>>>>
>>>>> sysuse auto, clear
>>>>> describe, replace
>>>>> export excel name varlab using varlabs
>>>>>
>>>>>
>>>>> On Mon, Aug 19, 2013 at 2:04 PM, Nick Cox <njcoxstata@gmail.com>
>> wrote:
>>>>>> You could do something like this assuming that you don't have
> more
>>>>>> variables than observations.
>>>>>>
>>>>>> gen varname = ""
>>>>>> gen varlabel = ""
>>>>>> local i = 1
>>>>>> quietly foreach v of var * {
>>>>>> replace varname = "`v'" in `i'
>>>>>> replace varlabel = "`: var label `v''" in `i'
>>>>>> local ++i
>>>>>> }
>>>>>>
>>>>>> and then export those two variables. But Roger Newson's
> -descsave-
>> is
>>>>>> much more versatile and elaborate. -search descsave- for
> locations.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Nick
>>>>>> njcoxstata@gmail.com
>>>>>>
>>>>>>
>>>>>> On 19 August 2013 18:39, Caroline Wilson <wilson_cj@hotmail.com>
>> wrote:
>>>>>>> Hi Stata,
>>>>>>>
>>>>>>> I'm trying to output the names of all variables in my Stata
> dataset
>> and their labels to an excel file. For example, I would like to end
>> product to look like this:
>>>>>>>
>>>>>>> Variable name Variable label
>>>>>>> gender Patient gender
>>>>>>> DOB Date of birth
>>>>>>> Race Patient race
>>>>>>> etc.
>>>>>>>
>>>>>>> Is there an easy way to do this? I tried codebook but it gave me
> a
>> lot more information than I needed, and I also had formatting problems
>> when copying and pasting the output into Excel.
>>>>>>>
>>>>>>> Many thanks in advance for any help!
>>>>>>> Caroline
>>>>>>> *
>>>>>>> * 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/
>>>>> *
>>>>> * 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/
>>> *
>>> * 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/
>
> *
> * 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/