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?
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.