Hello, is there a way to automatically generate a pre-formatted XLSX? The reason is that I need to set a timer to generate a XLSX. Proc export is not useful because it is stripping the formatting; setting up a libref (libname ... xlsx) also seems to be a data-dump only. Now, ODS has formatting, but I need to manually download the XLSX. Is there some way to automate the downloading? Thanks!
ods Excel file="&SASFolder.&FirstReport"
style=Journal
options(sheet_name="Data" frozen_headers="1");
proc print data=FirstReport noobs; run;
ods Excel close;
You can use the Copy Files task for this and automate in your flow. Here -- I have a video tutorial (11 minutes within this much larger tutorial) that shows how to do this.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.