SAS Institute. The Power to Know

Knowledge Base

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