Hi,
I have an Excel spreadsheet (someone else created it) with three worksheets. Two have data sets that I have transferred by cutting and pasting into Stata and merging. The third has four columns:
Column 1: variable name data set 1
Column 2: variable label data set 1
Column 3: variable name data set 2
Column 4: variable label data set 2
Is there a way to link the variable names and labels (by cutting and pasting?) into the merged data set without having to retype each of the labels? I presume that you can't do all of this at once, if at all, but column by column would be great.
Many thanks,
Ric Uslaner
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/