Thousands of SAS users are migrating from SAS University Edition to SAS OnDemand for Academics (ODA). I thought I would share some of my thoughts, having just finished two books using ODA (Getting Started with SAS Programming: Using SAS Studio in the Cloud and A Gentle Introduction to Statistics Using […]
Migrating from SAS University Edition to SAS OnDemand for Academics was published on SAS Users.
SAS’ Leonid Batkhan summarizes a lesser known but useful feature in SAS that allows you to bring Microsoft Excel functions into your SAS programs.
Using Microsoft Excel functions in SAS was published on SAS Users.
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.
As a SAS programmer, you are asked to do many things with your data — reading, writing, calculating, building interfaces, and occasionally sending data outside of SAS. One of the most popular outputs you may be tasked with creating is likely a Microsoft Excel workbook. Have you ever heard, “just […]
Making the most of the ODS Excel destination 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.