SAS Technical Papers » Base SAS Language, Procedures, ODS, and Macros
Papers Topic List |
| Date | Title | File Size |
| May 2008 | The REPORT Procedure: Getting Started with the Basics (PDF)
This paper introduces PROC REPORT syntax and functionality to audiences with little or no experience with PROC REPORT. You can use PROC REPORT in both windowing and non-windowing environments; however, this paper focuses on using PROC REPORT in a non-windowing environment. |
229 KB |
| March 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. |
64 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 |
| December 2006 | 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 |
| June 2006 | TS-758: Ensuring Compatibility of Encoding across Different Versions of SAS (PDF) | 84 KB |
| February 2006 | TS-751: Presentation-Quality Tabular Output via ODS (PDF) | 65 KB |
| February 2006 | TS-749: A Reintroduction to ODS: The Philosophy of the Output Delivery System (PDF) | 126 KB |
| January 2006 | TS-747: Using ODS to Create High-quality Hardcopy in SAS v8 (PDF) | 390 KB |
| 17Aug05 | TS-741: Effective Data Encrypton 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 |
| 26Feb02 | TS-673: Reading Delimited Text Files Into SAS | 17 KB |
| 12Nov01 | TS-668: SAS Dates, Times, and Interval Functions | 93 KB |
| 01Nov01 | TS-665: Basics of Report Writing - What's New? (PDF) | 113 KB |
| 01Nov01 | TS-664: A DATA Stepper's Introduction to ODS (PDF) | 165 KB |
| 02Jul01 | TS-654: Numeric Precision 101 (PDF) | 247 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-289: Syntax for Old Style Macros | 8 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 |
| 11Mar93 | TS-271: An Overview of Transporting SAS Files Between Hosts | 36 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 |