06-06-2017 05:33 PM
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";
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?
06-06-2017 06:57 PM
Honestly, I don't know. However, you can use the LABEL option with proc export using the DBMS=XLSX option.
Art, CEO, AnalystFinder.com
06-06-2017 08:52 PM
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.