Systems Seminar Consultants, Inc.
The Missing Semicolon
Volume 13 Number 2 February / 2012

Arrays Made Easy


Many programmers often find the thought of using arrays in their programs to be a daunting task, and as a result they often shy away from arrays in their code in favor of better-understood, but more complex solutions. 
A SAS array is a convenient way of temporarily identifying a group of variables for processing within a data step. Once the array has been defined, the programmer is now able to perform the same tasks for a series of related variables.  Once the basics of array processing are understood, arrays are a simple solution to many program scenarios.


Read More

ETL Anatomy 101

Extract, Transform, and Load (ETL) isn't just for data warehouses. This paper explains ETL principles that can be applied to any application that handles data feeds for reporting, decision support, modeling, and a data warehouse/mart. Here we will expand on "Introduction to Business Intelligence" by drilling down into the ETL component of BI systems. The goal is to demystify ETL terminology, explain ETL design, and show how your project can benefit from ETL or an ETL-like process.
Quick Tip: The Best Debugging Statement: PUTLOG

Click to Read More
Quick Tip: Custom Report Styles with SAS Enterprise Guide
Click to Read More
Check Us Out on Facebook and Twitter!
Receive discounts, instant updates,
SAS tips and upcoming events!
Like us on Facebook   Follow us on Twitter   View our profile on LinkedIn
Dear SAS User,

Since the beginning of the year, we have been preparing for 2012 SAS conferences.  They are a great opportunity to network with other users, learn what's new and upcoming in SAS software, and share your tips with others.


We will be presenting papers at the SAS Global Forum in Orlando, April 22-25, 2012.  Steve First will be presenting The SAS Log: A Wealth of Data and Job Flow Information.  We will also be presenting Productivity Tips for SAS Enterprise Guide Users.  If you are able to attend the conference, we hope to see you there!


I am also preparing for the Midwest SAS Users Group (MWSUG) in Minneapolis, MN, September 16-18, 2012.  I will be co-chairing the BI Applications and Architecture section.  I am also putting together ideas of papers that I could present.  The call for papers will be opening March 12, so don't forget to submit your ideas at


Finally, we are also starting the planning of our local meeting, Wisconsin SAS Users Group (WISUG).  We will be having our annual meeting on May 3, 2012.  We are finalizing speakers and details, so stay tuned for the formal invitation.


Please think about how you can be involved in SAS user groups.   It is an inexpensive way to get training on a variety of topics, keep up to date with the latest technology, network with others in your industry, and share your knowledge with others.  SAS conferences are definitely worth the time and cost for any SAS user.


Thanks for Reading!

Jennifer First

Director of Operations


SAS® Macros: February 27-28 

Advanced SAS®: March 12-14
Advanced SAS® Macros: March 21

SAS® SQL: March 22
Intro to SAS®: May 14-16
SAS® Enterprise Guide: May 17-18 

If someone signs up for a class and refers your name, receive 25% off your next class!

Need Help Administering Your SAS Environment?



We Can Customize a Plan

To Optimize Support and Minimize Cost


    Contact Us




Systems Seminar Consultants | | 1.800.997.7081  | 2997 Yarmouth Greenway Drive | Madison, WI 53711 



Copyright © 2012 Systems Seminar Consultants, Inc. Madison, WI. All rights reserved. Printed in USA. 
The Missing Semicolon is a trademark of Systems Seminar Consultants, Inc. SAS is a registered
trademark of SAS Institute Inc. in the USA and other countries.