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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.