Export with Variable Lables

[Alankar]

Is there any way to export the data to Excel file with Labels instead of variable names?

Thanks in Advance,
Alankar

[sbb]

PROC EXPORT supports using labels but only starting with SAS 9.2. Otherwise, you can use ODS CSV and PROC PRINT as an alternative, or explore using the SAS-distributed macro found in SASAUTOS (auto-call macro library) %DS2CSV.

Scott Barry
SBBWorks, Inc.

[Alankar]

Thanks sbb,

I'm trying to export using ODS HTML FILE;
but I've one char variable with following values :
0009
0034
in the result i'm getting like this:
9
34
I need as it is.
define code / format = $5.; is not working.

help me.

[GertNissen]

Try format = z4.;