If you have been using SAS for long, you have probably noticed that there is generally more than one way to do anything. (For an example, see my co-author Lora Delwiche’s blog about PROC SQL.) The Little SAS Book has long covered reading and writing Microsoft Excel files with the […]
Accessing Excel files using LIBNAME XLSX was published on SAS Users.
This article demonstrates the ODS Excel destination’s flexibility and how you can modify its default behavior by using the SHEET_INTERVAL= option.
Control the location of tables, graphs, and text with ODS Excel was published on SAS Users.
When you weren’t watching, SAS did it again. We smuggled Yet Another Excel Engine into a SAS release. SAS 9.2 Maintenance 2 added the XLSX engine, which allows you to read and write Microsoft Excel files as if they were data sets in a library. The big advantage of using […]
The post Using LIBNAME XLSX to read and write Excel files appeared first on The SAS Dummy.
As you can tell from my recent posts (see here and here), I’ve been working with SAS and Microsoft Excel files quite a bit. I’m really enjoying the ability to import an XLSX file in my 64-bit SAS for Windows without any additional setup. After one long afternoon of back-and-forth […]
The post Don’t panic: maybe your XLSX file is already opened appeared first on The SAS Dummy.
I recently wrote about my foray into the experimental world of ODS EXCEL. Using this new destination in SAS 9.4, I was able to create multisheet workbooks — containing reports and graphs — in the XLSX format. I outlined some of the benefits — such as being part of Base […]
The post Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports appeared first on The SAS Dummy.
In case you missed it, the first maintenance release for SAS 9.3 was recently released. Because we’re all friends here, you may call it “SAS 9.3M1” for short. Maintenance releases are usually about fixing problems that SAS has found or that customers have reported. However, sometimes a new capability might […]