Help using Base SAS procedures

Export with Variable Lables

Reply
Contributor
Posts: 26

Export with Variable Lables

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

Thanks in Advance,
Alankar
Super Contributor
Super Contributor
Posts: 3,174

Re: Export with Variable Lables

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.
Contributor
Posts: 26

Re: Export with Variable Lables

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.
SAS Employee
Posts: 174

Re: Export with Variable Lables

Try format = z4.;
Ask a Question
Discussion stats
  • 3 replies
  • 96 views
  • 0 likes
  • 3 in conversation