Re: st: output variables and labels to excel

[Nick Cox <njcoxstata@gmail.com>]

The Statalist FAQ explains that you are expected to be using the
latest version unless you declare otherwise. -export excel- was not in
Stata 11.

Nick
njcoxstata@gmail.com


On 19 August 2013 21:35, Caroline Wilson <wilson_cj@hotmail.com> wrote:
> 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/
*
*   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/