I've created a multipage Excel report. The best tool I've found for most of the pages is ODS Excel with PROC REPORT, which will do far more than I'll ever need except in the case of one sheet that has several hundred columns and tens of thousands of rows. I'm using EG 7.13 HF6 (7.100.3.5513 64 bit) connecting to SAS on a server and getting out of (virtual) memory errors after a few minutes of processing. There is now a lot of disk space on that server. If there's a configuration suggestion, I'll pass it on to our SAS admin, who is not much of a SAS user otherwise. So, I can't use ODS EXCEL with PROC REPORT or PROC PRINT or whatever. I can't use DDE to send commands to an open Excel session reliably with SAS on a server, AFAIK. I've done it a lot on PC SAS, and even then there are glitches, like when another application pops up and grabs the Windows focus during a DDE operation. PROC EXPORT and LIBNAME ... XLSX methods don't allow me to format the cells/columns (CURRENCY, BORDERS, Filters, etc). I see someone mentioned using a JAVA bridge, though I haven't looked into it, partly because I hesitate to drag another tool and environment into it all. I've used JScript Windows Script Host scripts before to operate on Excel sheets and I considered that, maybe kicked off by EG. But in our environment WSH scripts are blocked. I'd rather not write VBA and have to have someone run them separately from the EG job that creates the output (aside from hating every dialect of BASIC I've ever seen, and I've used them a lot). What else can I do? I've run out of ideas. Thanks for any suggestions. David Greensboro, NC
... View more