Experimenting with ODS EXCEL to create spreadsheets from SAS

The ODS ExcelXP tagset has served us well over the years. It provides a reliable method to get formatted SAS output into Microsoft Excel workbooks, where the business world seems to like to live. And it's available in Base SAS, which means that you don't need SAS/ACCESS to PC Files […]

Post a Comment

Export to Excel 2010 just got a little bit easier

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 […]

Post a Comment

Behind the scenes: importing Excel files using SAS Enterprise Guide

I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of managing data in the same way […]

Post a Comment

Export to Excel 2007/2010 using SAS Enterprise Guide

Since its 4.2 release, SAS Enterprise Guide has been able to import Microsoft Excel 2007 and 2010 spreadsheet files (usually encountered as .XLSX files). But while SAS Enterprise Guide can export XLS files (which are compatible with all versions of Microsoft Excel), it does not have the ability to export […]

Post a Comment

Using SAS Enterprise Guide to read Microsoft Office 2007 files

Even if you don't use Microsoft Office 2007, you might have noticed more ".xlsx" files floating around lately. Perhaps you've been sent one or two that you can't open. XLSX is one of the new Microsoft Excel 2007 file formats. (Others include XLSB and XLSM.) Like many software applications, SAS […]

Post a Comment