SAS' Chevell Parker walks you through eight formatting scenarios that can occur when using ODS Excel and how to address them using formatting and formatting values after export.
Search Results: ODS Excel (300)
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
This article demonstrates the ODS Excel destination’s flexibility and how you can modify its default behavior by using the SHEET_INTERVAL= option.
The SAS® Output Delivery System provides the ability to generate output in various destination formats (for example, HTML, PDF, and Excel). One of the more recent destinations, ODS Excel, became production in the third maintenance release for SAS 9.4 (TS1M3). This destination enables you to generate native Microsoft Excel formatted
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 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
Not too long ago I had a report generation request from an Alaska state agency. The request had some very specific requirements that detailed the use of user defined colors (by name), data driven control of the report, and Excel delivery using ODS and PROC REPORT. Along the way I had
Since its founding in 1915, Bealls Inc., a privately held company, has been headquartered in Bradenton, FL. Today, it operates more than 650 retail locations in 23 states under the names Bealls, Bealls Florida, Home Centric and Rugged Earth Outfitters. Bealls is an off-price retailer focusing on quality brands, styles
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,
Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.
Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.
SAS' Leonid Batkhan summarizes a lesser known but useful feature in SAS that allows you to bring Microsoft Excel functions into your SAS programs.
For many retailers, the biggest challenge was simply to have enough staff to get products onto shelves quickly enough.
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
有安裝 SAS/ACCESS to PC Files 產品時 LIBNAME EXCEL 直接讀寫既有 Excel 檔案。SAS 與 Microsoft Office 需同為相同的 32-bit (或 64-bit) 應用程式。 LIBNAME myxls EXCEL PATH='C: mpprdsale.xls'; LIBNAME PCFILES –同 LIBNAME EXCEL 直接讀寫既有 Excel 檔案。但須使用 SAS PC Files Server LIBNAME myxls PCFILES SERVER=localhost PATH='C:prdsale.xls'; PROC EXPORT DBMS=EXCELCS :使用SAS PC Files Server讀寫既有 Excel 檔案。
In a move to combat "stataphobia" and foster excellence in statistics in developing countries, SAS Press last month donated 70 SAS Press titles to the Serageldin Research Library at the Library of Alexandria in Egypt. The library’s mission is to achieve statistical equity so that a student in Chad has
Ok, so you know how to create multiple sheets in Excel, but can anyone tell me how to control the name of the sheets when they are all created at once? In the ODS destination for Excel, the suboption SHEET_INTERVAL is set to TABLE by default. So what does that
Are you a visualization & graphing expert? Can you identify which tool (R, Excel, Tableau, SPSS, Matlab, JS, Python, or SAS) was used to create each of these graphs? No cheating! I recently read Tim Matteson's blog where he presented 18 graphs, and had his readers try to guess which
Are you the lone-wolf SAS programmer in your company - managing the data, performing the analyses, and graphing the output for everyone else? And what's the only format they all know how to work with, and wish they had your output in? Let's face it ... that's probably an Excel
Multi-echelon inventory optimization is ever more a requirement in this era of globalization, which is both a boon and bane for manufacturing companies. Optimizing pricing is also important. Global reach allows these companies to expand to new territories but at the same time increases the competition on their home turf.
The ODS statement controls most aspects of how SAS creates your output results. You use it to specify the destination type (HTML, PDF, RTF, EXCEL or something else), as well as the details of those destinations: file paths, appearance styles, graphics behaviors, and more. The most common use pattern is
I previously wrote about the best way to suppress output from SAS procedures. Suppressing output is necessary in simulation and bootstrap analyses, and it is useful in other contexts as well. In my previous article, I wrote, "many programmers use ODS _ALL_ CLOSE as a way to suppress output, but
If you have programmed with SAS in the last 15 years, you have probably had a reason to share your SAS results in PDF format. The ODS PDF destination, much like a well-designed car, has evolved over the years, offering progressively nicer features like security, enhanced image formatting and embedded
The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.
In Microsoft Excel, a PivotTable can help you to create an interactive view of summarized data. Within a PivotTable, it’s easy to adjust the dimensions (columns and rows) and calculated measures to suit your ad-hoc reporting needs. You can also create a PivotChart – similar in concept to a PivotTable, but
When you run a program or task in SAS Enterprise Guide, the application wraps your job in an "ODS sandwich", the colloquial term we use for the ODS statements necessary to create output that can be viewed in your project. That's convenient for exploring and refining your program, but at
February is Heart Month First the bad news, heart disease is the number one killer of both men and women. Now the good news, heart disease is preventable and controllable. Chews Strategically will focus on the health of your heart for the month of February so tune in and learn
The ODS DOCUMENT and the DOCUMENT procedure give you the ability to save ODS output. Once saved, you can print that same work, as many times as you want, to any ODS destination. But what does this mean for you? With PROC DOCUMENT, you can: Make changes to the appearance
Neil Constable is a Principal Education Consultant at SAS in the United Kingdom, where he applies his extensive knowledge of Base SAS, SAS Enterprise Guide, and the SAS business intelligence tools. He's also the author of SAS Programming for Enterprise Guide Users, Second Edition--and this week's featured tip. You can get to know Neil
This question came up while helping my presales colleague with a client’s question: “Is Microsoft Excel in direct competition with SAS?” Not really. I like to think of SAS as partnering with Excel. Because of the following Excel benefits and its synergy with SAS. Excel has been around for years.