Systems Seminar Consultants, Inc.
The Missing Semicolon

Volume 13 Number 8                    Subscribe Here!
August / 2012

Dear SAS User,


We are getting very excited about the  Midwest SAS Users Group meeting coming up on September 16-18!  It will be 3 wonderful days of training, presentations, networking, and meeting with SAS.  


Thomas Miron from SSC will be presenting, and I will be co-chairing the BI Applications Section.  Steven First will be teaching a pre-conference training course, SAS Report Writing on September 14th.  To register, visit


It's not too late to register for the conference!  If you are unable to attend, don't forget to check out the proceedings which will be published online at 


If you are not in the Midwest, check out what other SAS user group conferences are available in your geographic area or industry at


Thanks for Reading!

Jennifer First
Director of Operations 


In-Database Processing in SAS


An exciting enhancement to SAS was included in SAS version 9.2.  In this release the SAS/Access product was enhanced to enable in-database processing.  The new in-database technology allows select procedures to process inside of the database.  This technology allows the programmer to use the power of SAS while leveraging the scalability and processing power of the database platform for select procedures.


Learn More about In-Database Processing 

Available At Your Site, Using Your Databases

Contact for details
Dear Miss SASsy:  

Dear Miss SASsy, 


In the example given in "Why Do We Need Arrays" -- obviously the SAS code length is much shorter when using the array + loop compared with doing all 24 calculations with 1 calculation per line.  How does the processing time compare with the two different syntaxes?

Obviously the arithmetic time will be the same since SAS has to do the math either way -- but if we expand the example to say 1 million calculations; is there a processing power penalty for the do loop and the array vs explicitly stating the calculation line by line






Send your SAS questions to Miss Sassy! 


Email:, if your question is featured in a newsletter, we will send you a free gift! 


Quick Tip


How to get file characteristics, such as file size and create date.  


Read more

Principles of Good 

System Design

Webinar Recording


Presentation Slides  



Coming Up:


SAS Efficiencies 

September 13, 2012,
Noon Central Time

Quick Tip


Organize your Enterprise Guide projects with multiple process flows


Read more



Check us out at MWSUG!


September 16-18, 2012

Minneapolis, MN


Pre-Conference Training:

SAS Report Writing

Steven First



Using Enterprise Guide Effectively

Thomas Miron

Follow Us!

Receive discounts, instant updates,
SAS tips and upcoming events! (And a chance to win a FREE training class!)


Like us on Facebook   Follow us on Twitter   View our profile on LinkedIn


 Fall SAS Training!

 Available As Live Web or At Our Training Facility in Madison, WI 




Introduction to SAS - September 17-19  


SAS  Enterprise Guide - September 20-21 


SAS  Macros - September 24-25            


Advanced SAS Macros - September 26


SAS  SQL Procedure - September 27      


SAS  Efficiencies - September 28


SAS  Report Writing - October 15-16

 Advanced SAS - October 22-24




Contact 1-800-997-7081 or for details

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.