Tag: ODS EXCEL

Creating a Microsoft Excel report using SAS, Python and SQL!

The addition of the PYTHON procedure and Python editor in SAS Viya enables users to execute Python code in SAS Studio. This new capability in SAS Viya adds another tool to SAS’s existing collection. With this addition I thought, how can I utilize this new found power? In this example, […]

Creating a Microsoft Excel report using SAS, Python and SQL! was published on SAS Users.

Using LIBNAME XLSX to read and write Excel files

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.

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

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.