Automating Excel workbooks creation using SAS
Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.
Tag: ods
A comparison of the ODS destinations for writing to Microsoft Word
There are several alternatives to writing to a Microsoft Word file when you use the SAS® Output Delivery System (ODS). The RTF, TAGSETS.RTF and TAGSETS.RTF_SAMPLE destinations create an RTF formatted file. The WORD destination, which is still considered preproduction, creates a DOCX formatted file. The destinations provide many of the same functions, although some features are unique to each one. The destination that you choose might vary depending on your desired final output.
How to Add Sticky Headers with ODS HTML
This blog demonstrates how to modify your ODS HTML code to make your column headers “sticky,” or fixed in position. Using sticky headers is most beneficial when you have long tables on your web page and you want the column headers to stay in view while scrolling through the rest of the page.
3 ejemplos inspiradores de la Analítica en Acción compartidos en #SASGF
Para quienes trabajamos en el mundo de la analítica, nos resulta cada vez más sencillo explicar cuál es el impacto social de nuestro trabajo y por qué el desarrollo de esta ciencia -que tomamos profesionalmente- es un tema que nos apasiona tanto. Nosotros sabemos que la analítica es capaz de cambiar el
How to view or create ODS output without causing SAS® to stop responding or run slowly
SAS makes it easy for you to create a large amount of procedure output with very few statements. However, when you create a large amount of procedure output with the Output Delivery System (ODS), your SAS session might stop responding or run slowly. In some cases, SAS generates a “Not
Embed scalable graphics using the ODS HTML5 destination
Beginning with SAS® 9.4, you can embed graphics output within HTML output using the ODS HTML5 destination. This technique works with SAS/GRAPH® procedures (such as GPLOT and GCHART), SG procedures (such as SGPLOT and SGRENDER), and when you create graphics output with ODS Graphics enabled. Most (if not all) existing
Custom Style Templates: Start Small
SAS author Jane Eslinger shows give you tips for working with PROC TEMPLATE when diving into the Output Delivery System (ODS) world. Learn how to create a custom style template to get the stylized output you want.
Background images and the ODS destination for PowerPoint
The ODS destination for PowerPoint uses table templates and style templates to display the tables, graphs, and other output produced by SAS procedures. You can customize the look of your presentation in a number of ways, including using custom style templates and images. Here we'll learn about using background images.
The many faces of HTML
Generating HTML output might be something that you do daily. After all, HTML is now the default format for Display Manager SAS output, and it is one of the available formats for SAS® Enterprise Guide®. In addition, SAS® Studio generates HTML 5.0 output as a default. The many faces of
Displaying the upper or lower triangle of a correlation matrix
This post shows ways to display the upper or lower triangle of a correlation matrix. You can also use colors to show the magnitude of the correlations.
The ODS Destination for PowerPoint Has a New Option
Have you heard? The ODS Destination for PowerPoint Has a New Option It’s true. The ODS destination for PowerPoint now has the STARTPAGE= option, which provides you with greater control and flexibility when creating presentations. Added to the ODS POWERPOINT statement in SAS® 9.4TS1M4, the STARTPAGE= option enables you to
Creating reports in style with SAS Enterprise Guide
“The difference between style and fashion is quality.” -Giorgio Armani With an out-of-the-box SAS Enterprise Guide (EG) installation, when you build a report in SAS EG it is displayed in a nice-looking default style. If you like it, you can keep it, and continue reading. If you don’t quite
Advanced ODS: Controlling precisely what output is displayed
PROC SGPLOT displays titles inside the graph. If you want to display a title inside the graph and a different title outside the graph, you can use the ODS LAYOUT or the GTL. The ODS LAYOUT gives you precise control over your output and enables you to display multiple graphs and tables in each page.
Capturing output from any procedure with an ODS OUTPUT statement
There's an old song that starts out, "You Can Get Anything You Want at Alice's Restaurant." Well, maybe you are too young to know that song, but if you’re a SAS users, you’ll be glad to know that you can capture anything produced by any SAS procedure (even if the
Advanced ODS Graphics: Remove ODS Subtitles
In my previous post, I showed you how to change the titles in graphs produced by analytical procedures; today I will show you how to remove subtitles that procedures display on some output pages. The following step creates output that contains a SAS title ('Illustrate the CIF Plot'), a PROCTITLE
Do you need multiple graphs on a page? We have got you covered!
If you use SAS® software to create a report that contains multiple graphs, you know that each graph appears on a separate page by default. But now you want to really impress your audience by putting multiple graphs on a page. Keep reading because this blog post describes how to
Tips for working with Color Names, Formats, Macros, ODS, Excel®, and PROC REPORT
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
Using the ODS statement to add layers in your ODS sandwich
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
Specifying Unicode values and colors easier with PROC SGPLOT and GTL
Many users of ODS Graphics will be excited to learn that, beginning with SAS® 9.4 TS1M3, SG procedures are able to recognize formatted values that contain Unicode values. One benefit of this is that it allows you to include, without using annotation, special symbols such as greater-than-or-equal-to signs or Greek
SAS ODS destination - Google maps
➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in
ODS PDF destination in SAS 9.4: Come take a look under the hood!
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
Have you created Scalable Vector Graphics with SAS?
If you haven’t tried them for your web applications and other graphics needs, you’ll want to read further! Scalable Vector Graphics (SVG) output is vector graphics output you can display with most (if not all) modern web browsers. Because SVG graphic output is scalable, you can zoom in on the
Experimenting with ODS EXCEL to create spreadsheets from SAS
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
Take control of ODS results in SAS Enterprise Guide
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
Adding Google Web Fonts to your SAS reports
Because I began my SAS career in the Publications division, I like to think that I have a keen eye when it comes to SAS documentation. When I first visited the SAS 9.4 online documentation, I immediately noticed that it had a different look. Examine the image below; can you
SAS author's tip: Using ODS to send output to alternate destinations
Ron Cody starts things off right with our first SAS tip of 2014. If you resolve to become a better statistical programmer this year, Ron's book SAS Statistics by Example is a great place to start. After you take a look at this week's free excerpt from the book, head over to Ron's author page. You'll
SAS author's tip: Naming ODS output
This week's SAS tip is from Michael Tuchman and his innovative book PROC DOCUMENT by Example Using SAS. Michael's book fills an important gap. For instance, in her review of the book, SAS user and senior statistical analyst Wendi Wright said: "Currently, I believe PROC DOCUMENT is a highly underused procedure and after reading
SAS author's tip: Moving ODS output into your internet or intranet site
This week's SAS tip is from Lauren Haworth, Cynthia L. Zender, and Michele Burlew's book Output Delivery System: The Basics and Beyond. This example-driven book includes broad coverage of some of the best features of ODS. To learn more about the book and the authors, visit our Web catalog to read
SAS author's tip: Turning off output to the results window
This week's SAS tip is from Lauren Haworth, Cynthia L. Zender, and Michele Burlew's book Output Delivery System: The Basics and Beyond. This monumental guide is packed with a wide-array of techniques and examples. As SAS programmer Christine Iodice said, "This book is one-stop shopping for all your ODS needs!"
An easy way to find variables in common to data sets
Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, Ms. Trixie