The SAS Output Delivery System and reporting techniques

libname xlsx engine options

Occasional Learner
Posts: 1

libname xlsx engine options



I am currently using the new xlsx engine to generate my spreadsheets.  Works pretty darn good.  However, I have one example where I want sas to generate the column headers using the labels in the sas dataset.  This is running on a Linux box, with 9.4,

NOTE: SAS (r) Proprietary Software 9.4 (TS1M3)

Linux LIN X64 2.6.32-642.13.1.el6.x86_64 #1 SMP Wed Nov 23 16:03:01 EST 2016 x86_64 Red Hat Enterprise Linux Server release 6.8


Here is my code:

%let myfile = Prod_code_XREF_Bus_Cnsmr_&mmmyyyy..xlsx;
%let mytarget = &folder./&myfile.;


libname xl XLSX "&mytarget";


data xl.Sheet1;
  set prodhier;


libname xl clear;




Is there an option that can be set to say "use the var labels for column names" as you could with proc export?

Posts: 8,164

Re: libname xlsx engine options

Honestly, I don't know. However, you can use the LABEL option with proc export using the DBMS=XLSX option.


see: chrome-extension://oemmndcbldboiebfnladdacbdfmadadm/


Art, CEO,

Super User
Posts: 23,724

Re: libname xlsx engine options


The usual option is DBLABEL which doesn't appear to work with XLSX engine as far as I can see. 

Smiley Sad


I used to use this with EXCELCS and EXCEL via LIBNAME.

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation