I am using SAS version 9.4 TS Level 1M3. I have a snippet of code below that creates an Excel Spreadsheet with the fomatting I want however, as soon as I finish running the code Excel opens. I plan to run this in batch mode at night when I am not awake and then send a link to the created spreadsheet to a number of users. I know if I use PROC EXPORT or the Libname statement to create the XLSX file the spreadsheet does not open, but the format is not "PRETTY". Is there anyway using ODS Excel to keep the spreadsheet from opening? Thanks for any help/advice you can provide. John Code Snippet: filename library 'C:\library.txt' ; %include library; options missing = ''; ods _ALL_ close ; ods excel file="O:\Folder\Exception Extracts.xlsx" options( sheet_interval="Proc" suppress_bylines="yes" sheet_name='Sheet Name' autofilter='all' frozen_headers='on' ); proc report data=work.low_bal; columns field1 field2 field3 field4 field5 field6 field7 field8 field9; define field1 / display; define field2 /display format=8.2 style=[tagattr="format:#,####0.00"]; define field3 / display format=8.2 style=[tagattr="format:#,####0.00%"]; define field4 / display; define field5 / display; define field6 /display; define field7 /display; define field8 /display; define field9 /display format=8.2 style=[tagattr="format:#,####0.00"]; run; quit; ods excel close;
... View more