Welcome to MSUG: Michigan SAS Users Group

 
  • Home
  • News
  • Meetings
  • Links
  • Contact Us
  • Presentations
  • Jobs

PROC REPORT in Cartoons: The Logic Behind the Scenes

This talk, with its animated cartoon format, explains the details of the underlying processes that let us do calculations in PROC REPORT. Knowing these processes makes it easier to code PROC REPORT so that just one PROC produces a finished report. The presentation assumes no exposure to PROC REPORT and then takes attendees to the level of producing complicated reports with percentages within groups. This talk does not cover formatting and borders.

This talk focuses on doing calculations in PROC REPORT and explains:
  • The three processes internal to PROC REPORT.
  • The secret, internal, PROC REPORT working file and how to use it.
  • Order of execution of PROC REPORT internals and how knowing the order helps you
  • Making reports with complicated percentage calculations
Some experience with PROC REPORT is helpful, but not required.

An Animated Guide: Introduction to SAS Hashing

Hashing is one of the fastest “table lookup” techniques, not just in SAS, but in any programming language. The presentation covers the concept of a “table lookup” and the speed advantage of SAS V9 hashing over a SAS format table lookup. If a programmer needs to select, from a large file, all subjects that are in a small file, hashing will likely save both disk space and time. Hashing should be part of the tool kit of every programmer who deals with large files.
Picture

About the Presenter

Russ Lavery is a frequent and multiple award-winning presenter at SAS user groups. He has been a technical reviewer on five books on SAS and statistical topics. He has over 25 years of experience using SAS and is still studying. Russ is a contractor and lives outside Philadelphia, PA, where he occasionally teaches as an adjunct in the Drexel University analytic program and dances frequently.

Powered by Create your own unique website with customizable templates.