RE: st: output variables and labels to excel

["Radwin, David" <dradwin@rti.org>]

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/