SAS Technical Papers » Base SAS Language, Procedures, ODS, and Macros
Papers Topic List |
| Date | Title | File Size |
| July 2009 | TS-673: Reading Delimited Text Files Into SAS®9 | 94 KB |
| March 2009 | A SASŪ Output Delivery System Menu for All Appetites and Applications (PDF) This document describes how to unleash the power of various ODS destinations to generate fantastic applications and reports. |
1.4 MB |
| March 2009 | ODS Packages: Putting Some Zip in Your ODS Output (PDF) Learn how easy it is to use ODS packages and find out how they will impact the future of ODS. |
113.8 KB |
| March 2009 | Scalability of Table Lookup Techniques (PDF) This paper examines the issues of memory and disk space consumption and performance considerations for various table lookup techniques using large amounts of data. |
100.8 KB |
| March 2009 | Breaking New Ground with SASŪ 9.2 ODS Layout Enhancements (PDF) This paper discusses the latest enhancements to ODS Layout that enable you to produce stunning brochures, killer Web sites, jaw-dropping dashboards, and breathtaking documents. |
1.3 MB |
| March 2009 | Customizing FREQ Procedure Output in SAS 9.2 (PDF) This paper introduces the new crosstabulation table template, which enables you to customize PROC FREQ output and highlights how to use the template to accomplish some common tasks. |
543 KB |
| March 2009 | CSSSTYLE: Stylish Output with ODS and SAS 9.2 (PDF) This paper provides an introduction into the use of the new CSSSTYLE option in SAS 9.2. This option allows you to use cascading style sheet (CSS) style specifications for RTF and PDF files, in addition to HTML files. This paper includes a brief introduction to CSS syntax and some of the features, such as @media CSS sections, that are particularly useful when creating ODS output. |
439 KB |
| March 2009 | Dear Miss SAS Answers: A Guide to Efficient PROC SQL Coding (PDF) This paper answers commonly asked questions and helps you harness the potential of Structured Query Language. |
3.32 MB |
| March 2009 | Have It Your Way: Rearrange and Replay Your Output with ODS DOCUMENT (PDF) This paper illustrates how to capture your output and save it in an Output Delivery System (ODS) Document store. Then you can create custom folders and a custom folder hierarchy using ODS DOCUMENT and PROC DOCUMENT in order to rearrange and replay your output. |
1.25 MB |
| March 2009 | The Power to Show: Ad Hoc Reporting, Custom Invoices, and Form Letters (PDF) This paper demonstrates new features that allow you to build custom data-centric reports in an easy-to-use object-oriented manner that is fully integrated with the ODS System. This technology is perfectly suited for creating custom invoices, inserting narrative descriptions in a table or document, creating form letters and non-rectangular reports, inserting custom subtotals, and it will address a variety of custom reporting needs. |
913 KB |
| March 2009 | Test-Driving the Improvements to the INFOMAPS Procedure and LIBNAME Engine (PDF) This paper is written for the customers with the role of utilizing the power of information maps in Base SAS. It will test drive the new features of the procedure and the engine. Common changes to both INFOMAPS products include support on all SAS BI platforms and the use of trusted peer connections. |
308 KB |
| March 2009 | Tiptoe through the Templates (PDF) This paper provides an overview of all the different template types and how they're used with the Output Delivery System. From style and table templates, that first appeared with SAS 7 to the newest graph templates that appeared with SAS 9.2, this paper provides an overview and several concrete examples for each template type. |
1 MB |
| November 2008 | Achieving Better I/O Throughput Using SGIO in the Microsoft Windows Environment (PDF) In the SAS System, SAS I/O. the most common input/output (I/O) processing, is performed on SAS files such as SAS data sets, SAS catalogs, and SAS index files. Most SAS I/O processing is sequential I/O, which means that the DATA step and SAS procedures read a data set from the beginning of the file to the end of the file. |
80.5 KB |
| August 2008 | Using Style Elements in the REPORT and TABULATE Procedures (PDF) You can create customized ODS output with PROC REPORT and PROC TABULATE by using the STYLE= option directly in the procedures. Knowing which option to use in order to change the attribute of a particular item in the output report can be a challenge. This paper addresses this challenge and illustrates how to use the STYLE= option in the REPORT and TABULATE procedures to customize output. |
822 KB |
| April 2008 | Better Hashing in SAS 9.2 (PDF) The DATA step hash object is one of the most versatile new features of Base SAS programming. For SAS 9.2, we introduce the ability to store duplicate keys in a hash object and have added a find frequency counter. In this paper, we leverage the duplicate key capability to implement true SQL-like joins as well as partial-key look-ups. |
65 KB |
| March 2008 | Creating Complex Reports (PDF) Are you confused about whether you need a detail report or a summary report? Do you wonder whether you're using the right reporting procedure for your report? Have you ever spent a lot of time going down the road with one procedure only to discover that you need to switch to a different procedure to get what you want or closer to what you want? |
299 KB |
| March 2008 | Modernize Your Business Reports Using ODS and SAS/GRAPH: A Case Study from SAS 8.2 to SAS 9.2 (PDF) This paper provides an example of business reports using Base SAS and SAS/GRAPH procedures and ODS in the three releases, highlighting improved quality of the reports and increasing ease of use. |
659 KB |
| March 2008 | Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS (PDF) This paper discusses using the XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. The information presented is new for 2008. |
528 KB |
| March 2008 | How to Add a Little Spice to Your PDF Output (PDF) Topics in this paper include how to apply new styles, the new SAS/GRAPH interaction, how to scale background images, how to use new fonts and Unicode characters, and much more, including a brief discussion of ODS layout. |
270 KB |
| August 2007 | What Happened to My Data? (PDF) This paper explains how classification variable values are handled when a FORMAT statement or FORMAT option is applied. Topics include grouping observations with one classification variable and with multiple classification variables. The supporting examples focus on Base SAS reporting procedures, PROC REPORT, PROC TABULATE, PROC SUMMARY, and PROC MEANS. |
45 KB |
| March 2007 | Beyond the Basics: Advanced PROC REPORT Tips and Tricks (PDF) This paper is a compilation of tips and tricks for producing PROC REPORT output. The three sections cover topics that: can be used with listing output and with the Output Delivery System (ODS), can only be used with an ODS destination; highlight new features and changes for PROC REPORT in SAS 9.2. |
271 KB |
| March 2007 | Adventures in Arrays: A Beginning Tutorial (PDF) This paper presents examples to explain what arrays are and how to use them. In addition to simple examples demonstrating arrays used to perform calculations, restructure data and look up values, the paper includes examples using multidimensional arrays for efficient table lookups. |
77 KB |
| March 2007 | PROC TEMPLATE Tables from Scratch (PDF) In this paper, you learn how to create and modify table templates, including how to add, remove, and move columns as well as headers and footers. You also learn how to apply styles, formats, and other visual effects, all from scratch. |
2,533 KB |
| March 2007 | The Output Delivery System (ODS) from Scratch (PDF) Using ODS, you can generate reports in formats such as HTML, XML, PDF, PostScript, RTF, and Microsoft Excel. This paper shows you how to generate reports with ODS, from scratch. You'll learn how to generate multiple output formats, simultaneously; how to change the look of your report using styles; how to add text passages; and other helpful information. |
1,859 KB |
| February 2007 | ODS Markup, Tagsets, and Styles! Taming ODS Styles and Tagsets (PDF) This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. |
469 KB |
| February 2007 | ODS and Office Integration (PDF) With so many ODS destinations available, it is increasingly important to know how the different file-formats integrate with external applications. Find out how easily you can create output in a multitude of file types, from the infinitely customizable XML to SpreasheetML, RTF, PDF, and LaTeX; even comma-separated values (CSV) get some attention in this paper. |
1,316 KB |
| 26Dec06 | Creating Multi-Sheet Excel Workbooks the Easy Way with SAS (PDF) This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). You will learn step-by-step techniques for quickly and easily creating attractive multi-sheet Excel workbooks that contain your SAS output. |
328 KB |
| 06Jul06 | TS-758: Ensuring Compatibility of Encoding across Different Versions of the SASŪ System in the z/OS Environment (PDF) Updated 09Nov09 | 708.5 KB |
| 28Feb06 | TS-751: Presentation-Quality Tabular Output via ODS (PDF) | 65 KB |
| 14Feb06 | TS-749: A Reintroduction to ODS: The Philosophy of the Output Delivery System (PDF) | 126 KB |
| 03Jan06 | TS-747: Using ODS to Create High-quality Hardcopy in SAS v8 (PDF) | 390 KB |
| 17Aug05 | TS-741: Effective Data Encryption Algorithms using the SAS System (PDF) | 320 KB |
| 26Jul05 | TS-739: Give Your Macro Code an Extreme Makeover (PDF) | 103 KB |
| 01Jun05 | TS-725: SASRX user documentation (PDF) | 63 KB |
| 15Jul04 | TS-706: How to use the %lswbatch macro (PDF) | 36 KB |
| 15Jul04 | TS-705: The Fundamentals of MERGE (PDF) | 86 KB |
| 23Feb04 | TS-696: Security Concerns and Best Practices for a SAS Grid (PDF) | 197 KB |
| 11Sep03 | TS-691: SAS encoding values, IANA preferred MIME charset, JavaTM and Oracle® encoding names | 256 KB |
| 12Nov01 | TS-668: SAS Dates, Times, and Interval Functions | 93 KB |
| 01Nov01 | TS-664: A DATA Stepper's Introduction to ODS (PDF) | 165 KB |
| 02Jul01 | TS-654: Numeric Precision 101 (PDF) | 247 KB |
| 08Aug01 | TS-611: Updating Data Using the MODIFY Statement and the KEY= Option (PDF) | 122 KB |
| 14Dec00 | TS-642: Reading EBCDIC Files on ASCII Systems | 34 KB |
| 10Oct00 | TS-639: Data conversion issues in v6-v8 which is of special interest for customers using languages other than English. (PDF) | 39 KB |
| 4Jun99 | TS-610: Basics of Report Writing in Version 6 (PDF) | 25 KB |
| 16Sep98 | TS-592: Tips and Techniques for Processing CRSPAccess97 CDROM Data with PROC DATASOURCE (PDF) | 8 KB |
| 08Jul98 | TS-581: Using FILEVAR= to read multiple external files in a DATA Step (PDF) | 10 KB |
| 15Jun98 | TS-580: Indexing in the SAS System, Version 6 (PDF) | 102 KB |
| 19Jun97 | TS-553: SQL Joins -- The Long and The Short of It | 38 KB |
| 19Jan96 | TS-486: Quick Reference Sheet for SAS Functions, Formats, and Informats (PDF) | 70 KB |
| 01Feb95 | TS-440: How can I use the COMPARE procedure to produce a report that shows the differences between two character values past the 20th character? (PDF) | 12 KB |
| 09Apr97 | TS-410: Ordering Data Values: Double Mapping and Combining Techniques | 90 KB |
| 09Apr97 | TS-408: Ordering Data Values: Dummy Data and Mapping Techniques | 54 KB |
| 09Apr97 | TS-407: Ordering Data Values: Procedure Defaults and Options | 51 KB |
| 17Nov94 | TS-396: The SAS System always prints numbers between 0 and 1 with leading zeros. How can I eliminate the leading zeros? | 8 KB |
| 01Nov94 | TS-378: How can I dynamically order the variables in MEANS procedure output by the descending mean values? | 11 KB |
| 19Jun97 | TS-320: Inside PROC SQL's Query Optimizer | 22 KB |
| 10Mar94 | TS-278: How to Guarantee That All Possible Values of a Class Variable will be Displayed in your Table Regardless of whether or not the Value Exists | 18 KB |
| 10Mar94 | TS-277: How to Restructure Your Data for an Answer Comparison Table | 9 KB |
| 21Apr97 | TS-250: DATA Step Programming Using the MODIFY Statement | 40 KB |
| 02Jan92 | TS-230: Dealing with Numeric Representation Error in SAS Applications | 59 KB |
| 03Nov98 | TS-140: The Record Layout of a SAS Transport Data Set | 64 KB |