An example-driven book geared to beginner and intermediate ODS users that will show you the many wonders of ODS. Beginning with basic syntax and progressing to more complex techniques and custom styles, you will learn to take basic SAS output and transform it into
You can also create a data set from the results of most procedures, allowing you to build your own custom reports. Each of the wide array of ODS techniques is presented in an easy-to-use, two-page layout with the text and code on one page and the resulting output on the facing page.
This book can be ordered at www.sas.com.
An abundance of real-world examples highlights this step-by-step guide to producing tables and reports using the TABULATE procedure.
Beginning and intermediate SAS users will find that the format is both convenient and inviting. Applications are presented in a self-contained, two-page layout; discussion material and sample code are on one page, and the resulting tables are on the facing page.
Topics are presented in order of increasing complexity, making this an excellent training manual or self tutorial. This concise format also lends itself as a quick reference guide for specific applications for more advanced uses. A very handy section on common problems and their solutions is also included.
With this book, you will quickly learn how to: generate tables using macros create tables using SAS/ASSIST software present output on the Internet handle percentages and missing data modify row and column headings produce one-, two-, and three-dimensional tables using PROC TABULATE. Also provided are more advanced tips on complex formatting and exporting PROC TABULATE output to other applications.)
This book can be ordered at www.sas.com.
Once you've started using the Output Delivery System, you'll quickly discover that your taste in output design probably doesn't coincide with the built in ODS styles shipped with SAS. To create output with more panache, you need to create your own style template.
This workshop will take you step by step through the process of creating a custom style for your output. You'll learn how to make minor modifications, and how to give your output a complete makeover. If you'd like all of your SAS output to be in hot pink on an acid green background with a gigantic script font, this workshop will show you how! Or, if you'd just like to make the output smaller and use colors that coordinate with your company logo, you can do that too.
The workshop will walk through the TEMPLATE procedure, showing how you can redefine the default style elements and attributes to customize fonts, colors, and borders to suit your own personal or corporate style. You'll be given a basic style template that you can customize during the workshop and then take home to try out on your ODS output.
HTML version: download a PDF copy , slide show, sample program
RTF version: download a PDF copy , slide show, sample program
PDF version: download a PDF copy , slide show, sample program
So you haven't gotten around to reading the entire PROC TEMPLATE chapter in Online Doc? The TEMPLATE procedure is incredibly powerful, but it’s also incredibly complex, and this chapter of the documentation is not an easy read. If you don’t have time to learn everything, but you want to be able to make basic changes to the appearance of your output, this is the workshop for you.
We’ll start out with a few syntax basics, and then focus on a number of shortcuts that will make customizing the style of your output quick and easy. Topics include viewing the source code for an Output Delivery System style, a point-and-click approach to modifying styles, and plenty of sample code snippets to use in your own programs. In no time you'll be impressing your boss and coworkers with beautiful reports. The presentation will include easy-to-use techniques for enhancing HTML, RTF, and PDF output.
Download my slide show and/or the sample programs
So you've got some SAS data and your boss wants a fancy table to present to senior management. Don't panic, SAS makes it easy to quickly generate high quality reports. This paper is a whirlwind tour of your SAS reporting options. It covers the REPORT procedure, the TABULATE procedure, and which is best to use for what types of reports.
After picking a procedure, the next step is to use the Output Delivery System to turn it into a web page, PDF file, Word document, PowerPoint slide, or Excel spreadsheet. This paper will show how to leverage ODS and Microsoft Office to deliver your results in the format most convenient for your customers.
Download a PDF copy, or my slide show.With more and more output being delivered via the Internet, a little knowledge of HTML can go a long way toward improving the appearance of your output. This paper introduces some simple HTML coding techniques that are useful for SAS programmers. The paper will show how your SAS output is converted into HTML, and demonstrate HTML tricks that you can use in your SAS code to dress up your SAS HTML output. All of the examples can be produced using either SAS version 6 or version 8.
Download a PDF copy, or my slide showSAS® Software provides hundreds of ways you can analyze your data. You can use the DATA step to slice and dice your data, and there are dozens of procedures that will process your data and produce all kinds of statistics. But odds are that no matter how you organize and analyze your data, you'll end up producing a report in the form of a table. This is why every SAS user needs to know how to use PROC TABULATE. While TABULATE doesn't do anything that you can't do with other PROCs, the payoff is in the output. TABULATE computes a variety of statistics, and it neatly packages the results in a single table.
Unfortunately, TABULATE has gotten a bad rap as being a difficult procedure to learn. This paper will prove that if you take things step by step, anyone can learn PROC TABULATE.
Download a PDF copy, or my slide showWith the Output Delivery System, PROC TEMPLATE can be used to create Rich Text Format (RTF) output with elaborate formatting to meet specific business needs.
When the results are opened in Microsoft Word, the output has exactly the fonts, sizes, weights, and borders that were specified. However, the output must be inserted into another Word document, this can all fall apart. An existing Word document uses Word styles to identify titles, headings, tables, and body text.
When a SAS-generated table is pasted in, it is assigned the Word style “Normal”. As a result, most of the custom ODS formatting is lost, and the output does not display properly.
The secret to solving this problem is to insert RTF tags for Word styles into the ODS output. Then when the results are pasted into another document, the styles are pre-applied, so the Normal style is not needed. The output maintains its original formatting.
Download a PDF copy, or my slide show.Are you thinking your next career move should be moving into a management position? Have you thought through all the pros and cons? This panel discussion will give you some things to think about before making that decision.
The panelists have had different experiences. One panelist moved into management - and then moved out of management. Another juggles management responsibilities with coding responsibilities. The other panelist focuses on managing people and projects. The panelists will share their experiences and provide an opportunity for you to ask questions.
Download a PDF copy, or my slide show.