topic Re: Automatically Downloading XLSX in ODS Excel in SAS Procedures

Automatically Downloading XLSX in ODS Excel

AndyTam — Wed, 24 Jun 2020 15:06:06 GMT

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;

Re: Automatically Downloading XLSX in ODS Excel

Reeza — Wed, 24 Jun 2020 15:25:38 GMT

What do you mean by manually download? That may be a limitation of your set up unfortunately.

Re: Automatically Downloading XLSX in ODS Excel

AndyTam — Wed, 24 Jun 2020 16:22:20 GMT

Actually ODS is already saving a formatted copy into my destination folder. I was asked to download it if I want to open it via EG. So it's an unrelated step.

Re: Automatically Downloading XLSX in ODS Excel

ChrisHemedinger — Wed, 24 Jun 2020 17:04:32 GMT

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.