Retrieving the variable labels with Stata

When working with large databases, it is quite easy to lose track about the signification of your variables. That’s why it is recommended to label your variables carefully and to export them in an Excel file. You can do it using the following:

preserve
    describe, replace
    list
    export excel using myfile.xlsx, replace first(var)
restore

The result in the Stata Results window describes the variables and give some information:

Then, the Excel file is produce and can be found in your working directory:

That’s all for today! Remarks and comments are welcome.