topic Re: Use SAS variable labels instead of variable names in Excel files exported with libname xlsx in SAS Programming

Use SAS variable labels instead of variable names in Excel files exported with libname xlsx

avz — Thu, 13 May 2021 14:24:43 GMT

I'm using this code to export labeled SAS data to Excel spreadsheets:

libname xlout xlsx "&root.\dataData\file.xlsx";
data xlout.data;
	set tables.data;
run;
libname xlout clear;

The result, however, is an Excel file with SAS variable names (e.g. dob) instead of variable labels (e.g. Date of Birth) as the column names. I would prefer having the SAS labels instead. Is this possible with libname xlsx?

Re: Use SAS variable labels instead of variable names in Excel files exported with libname xlsx

Tom — Thu, 13 May 2021 14:43:03 GMT

No. Use ODS EXCEL.

ods excel file="&root.\dataData\file.xlsx";
ods excel options (sheet_name="data");
proc print noobs label data=tables.data;
run;
ods excel close;

Re: Use SAS variable labels instead of variable names in Excel files exported with libname xlsx

avz — Thu, 13 May 2021 15:14:54 GMT

Thank you.

Re: Use SAS variable labels instead of variable names in Excel files exported with libname xlsx

Ksharp — Fri, 14 May 2021 13:03:19 GMT

data have;
 set sashelp.class;
 label sex='ssssss' name='nnnnnnnnnn';
run;

proc export data=have outfile='c:\temp\temp.xlsx' dbms=xlsx replace label;
run;

Or PROC EXPORT.