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

[avz]

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?

[Tom · Accepted solution]

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;

[avz]

Thank you. 

[Ksharp]

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.