The SAS Output Delivery System and reporting techniques

libname xlsx engine options

Reply
New User
Posts: 1

libname xlsx engine options

Hello,

 

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
      (Santiago)

 

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;
run;

 

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?

PROC Star
Posts: 7,363

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/http://support.sas.com/documentation/cdl/en/acpcref/69731/PDF/default/acpcref.pdf

 

Art, CEO, AnalystFinder.com

Super User
Posts: 17,826

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. 

 

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p1aksmchxr4bekn1bd...

Ask a Question
Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 3 in conversation