Posts Tagged ‘ xlsx ’

Using LIBNAME XLSX to read and write Excel files

May 20, 2015
By

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 Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Using LIBNAME XLSX to read and write Excel files

Don’t panic: maybe your XLSX file is already opened

September 24, 2014
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Don’t panic: maybe your XLSX file is already opened

Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

September 21, 2014
By

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 Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

Export to Excel 2010 just got a little bit easier

January 25, 2012
By

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
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Export to Excel 2010 just got a little bit easier

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.