st: output variables and labels to excel

[Caroline Wilson <wilson_cj@hotmail.com>]

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/