Export the list of variables with labels in Excel

[Clarisse Nguedam]

Dear all,

what is the command to export the list of variables with variables labels in Excel (only variables names and their labels without value labels)?

Thanks for your help.

Best ragards

[Leonardo Guizzetti]

This will get you to a useful place.

describe, replace
list
export pos name varlab excel using "myvariables.xlsx", replace firstrow(varlab)

[Clarisse Nguedam]

Thanks Leonardo, When I try the command
There is the following error message: export pos name varlab excel using "myvariables.xlsx", replace firstrow(varlab) export: unknown subcommand "pos" r(198) How ca I solve this problem? Thank you

[Clarisse Nguedam]

How can I solve the problem?

[Leonardo Guizzetti]

Thanks Leonardo, When I try the command
There is the following error message: export pos name varlab excel using "myvariables.xlsx", replace firstrow(varlab) export: unknown subcommand "pos" r(198) How ca I solve this problem? Thank you

I introduced a typo, my apologies. The command should be

export excel pos name varlab excel using "myvariables.xlsx", replace firstrow(varlab)

[Clarisse Nguedam]

Thanks Leonardo!