NJSUG

NJSUG 2011 Summer Meeting

The meeting was in the morning (9:00am - noon) on Friday, July 8th at:

Agenda

09:00-09:20	Registration and Continental Breakfast
09:20-10:30	Presentation: PROC FORMAT:The Basics and Beyond (Andrew Karp)
10:30-10:40	Break
10:40-10:45	Random Access (announcements)
10:45-11:55	Presentation: PROC MEANS:Basics and Beyond (Andrew Karp)
11:55-noon	Door Prize Drawings

Andrew Karp

This meeting offers two in-depth presentations by internationally recognized SAS Software expert Andrew Karp of Sierra Information Services. These Two 70-minute talks focus on core SAS BASE toos you can apply right away to simplify your report, data management, and analysis tasks.

Andrew Karp grew up in Central New Jersey and first learned about SAS Software while in graduate school at The George Washington University in Washington, DC. He is now in his 29th year of using SAS Software, his 23rd year of training others how to use it, and his 17th year as an independent SAS consultant. Since starting his firm, Sierra Information Services, in 1994 he has flown over 1.3 million air miles to participate in events for SAS users in 11 countries, has been an invited speaker at 16 consecutive SAS Global Forum meetings, and has served on the review teams for eight books published by SAS Press, an imprint of SAS Institute's Publications Division. Andrew now makes his home in the California Wine Country. He is an avid amateur photographer who is hard at work learning how to use his new Nikon D90 Digital SLR camera.

PROC FORMAT: The Basics and Beyond

Abstract

This 70-minute presentation starts with the fundamentals of Formats and their core role in the SAS System to display data values without having to change the values themselves. We will explore the use of SAS-supplied formats and how to create customized formats using PROC FORMAT. The presentation will then move on to more advanced/powerful aspects of the SAS Format facility, including using Formats to "bin" or "bucket" values of variables, the power of the MULTILABEL Format facility, creating "Formats within a Format," using Input Control Data Sets to assign Format labels without tedious coding, creating Formats to group/display data by fiscal years vs. calendar years, exploring the contents of Format Libraries with the FMTLIB option, and the how to use the PRELOADFMT option in the REPORT and TABULATE procedures.

Intended Audience: This talk is appropriate for users of SAS' syntax-based tools at all experience levels. The topics/concepts presented assume the attendee is already familiar with core SAS programming concepts such as data set, observation, variable, label, procedure, and data step.

PROC MEANS: The Basics and Beyond

Abstract

PROC MEANS offers SAS users a wide range of powerful tools to manage, report and analyze data. By attending this 70-minute talk you will learn about the core functionalities of this BASE SAS procedure, and then see some of the powerful "beyond the basics" tools you can use to rapidly aggregate, report and manage your data. Among the topics covered are: working with default PROC MEANS output, controlling procedure-generated display in your Output Window, selecting statistics to be computed, saving results in a SAS data set, creating multiple summary output SAS data sets with the CHARTYPE option, using the ORDER= option to control how your results are either displayed in the output window or stored in a new data set, the role of Multilabel Formats in PROC MEANS, the powerful AUTONAME and AUTOLABEL options to control how variable names and labels are assigned when PROC MEANS creates a SAS data set, and how to reduce processing time with the TYPES and WAYS statements.

Intended Audience: This talk is appropriate for users of SAS' syntax-based tools at all experience levels. The topics/concepts presented assume the attendee is already familiar with core SAS programming concepts such as data set, observation, variable, label, procedure, and data step.