topic Re: Export with Variable Lables in SAS Procedures

Export with Variable Lables

Alankar — Mon, 06 Apr 2009 06:15:43 GMT

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

Thanks in Advance,
Alankar

Re: Export with Variable Lables

sbb — Mon, 06 Apr 2009 06:40:27 GMT

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.

Re: Export with Variable Lables

Alankar — Mon, 06 Apr 2009 07:00:17 GMT

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.

Re: Export with Variable Lables

GertNissen — Mon, 06 Apr 2009 09:11:45 GMT

Try format = z4.;