topic libname xlsx engine options in ODS and Base Reporting

libname xlsx engine options

bassrick — Tue, 06 Jun 2017 21:33:37 GMT

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?

Re: libname xlsx engine options

art297 — Tue, 06 Jun 2017 22:57:06 GMT

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

Re: libname xlsx engine options

Reeza — Wed, 07 Jun 2017 00:52:00 GMT

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

😞

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

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