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.
Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.
Splitting a data table into multiple sheets of an Excel workbook was published on SAS Users.
Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.
Automating Excel workbooks creation using SAS was published on SAS Users.
This blog post, inspired by my work on this topic with a SAS customer, focuses on how to create and use locale-specific informats to read in numeric values from a Microsoft Excel file and then transform them into SAS character values. I incorporated this step into a macro that transforms ones and zeroes from the Excel file into meaningful information for multilingual readers.
Using locale-specific format catalogs to create reports in multiple languages 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.