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?
... View more