South Central SAS Users Group

11/7/2011

PROC TABULATE: Getting Started

Art Carpenter, California Occidental Consultants
9:00 am – 10:40 am

Although PROC TABULATE has been a part of Base SAS® since early version 6, this powerful analytical and reporting procedure is very under utilized. TABULATE is different; it’s step statement structure is unlike any other procedure. Because the programmer who wishes to learn the procedure must essentially learn a new programming language, one with radically different statement structure than elsewhere within SAS, many do not make the effort.

The basic statements will be introduced, and more importantly the introduction will provide a strategy for learning the statement structure. The statement structure relies on building blocks that can be identified and learned individually and in concert with others. Learn how these building blocks form the structure of the statement, how they fit together, and how they are used to design and create the final report.

A Hands-on Tour Inside DATA Step and PROC SQL Programming

Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, California
2:00 pm – 3:40 pm

Should the DATA step or SQL procedure be used to perform certain programming tasks? This hands-on workshop contrasts the similarities and differences between DATA step versus PROC SQL programming techniques including conditional logic concepts and constructs including IF-THEN-ELSE, SELECT-WHEN, and PROC SQL CASE expressions; and the techniques for constructing effective merges and joins.  Attendees explore examples that contrast DATA step versus PROC SQL programming techniques to conduct conditional logic scenarios, one-to-one match-merges and match-joins, and an assortment of inner and outer joins programming techniques.

11/8/2011

Using INFILE and INPUT Statements to Introduce External Data into the SAS^® System

Andrew T. Kuligowski
8:00 am – 9:40 am

The SAS^® System has numerous capabilities to store, analyze, report, and present data. However, those features are useless unless that data is stored in, or can be accessed by, the SAS System. This presentation is designed to review the INFILE and INPUT statements. It has been set up as a series of examples, each building on the other, rather than a mere recitation of the options as documented in the manual. These examples will include various data sources, including DATALINES, sequential files, and CSV files.

Practically Perfect Presentations

Cynthia L. Zender, SAS Institute, Inc., Cary, NC
10:15 am – 11:55 am

PROC REPORT is a powerful reporting procedure, whose output can be "practically perfect" when you add ODS STYLE= overrides to your PROC REPORT code. This hands-on workshop will feature several PROC REPORT programs that produce default output for ODS HTML, RTF and PDF destinations. Workshop attendees will learn how to modify the defaults to change elements of PROC REPORT output, such as HEADER cells, DATA cells, SUMMARY cells and LINE output using ODS STYLE= overrides. In addition, attendees will learn how to apply conditional formatting at the column or cell level and at the row level using PROC FORMAT techniques and CALL DEFINE techniques. Other topics include: table attributes that control interior table lines and table borders, use of logos in output and producing "Page x of y" page numbering.