Systems Seminar Consultants, Inc.
The Missing Semicolon

Volume 13 Number 7                     Subscribe Here!
July / 2012


Dear SAS User,


One of our favorite things to do at SSC is to talk to SAS users about how they can leverage SAS software for increased functionality and productivity.  The newest way that we are doing this is with our new monthly Lunch and Learn Sessions.  Our first session was a resounding success, with several hundred attendees.  If you missed it, you can view it here.  Our next session will be on Principles of Good System Design on August 16th.   


Not only are we holding public Lunch and Learn sessions, but we can also offer complimentary, private sessions for your organization.  If you are local, we can do it onsite, or we can do it is a web session.  We have dozens of topics that you can choose from.  This is a great way to get free SAS training for your group.  If you are interested, please email me directly, and we can set up your own free session. 



Thanks for Reading!

Jennifer First
Director of Operations 

Dear Miss SASsy:  

Dear Miss SASsy, 
I frequently upload spreadsheets from MS Excel. I use a SAS program to format, transform the data as needed, and map the data to a flat file.The first few rows contain text column headings. The column headings are useful but cause format errors during the INPUT statement. I can read the input, omit heading rows, and write data rows to a TEMP file; then read in the TEMP file with list input and formatted variables. Is there a better way? Can it be done with a single pass of the input file? The spreadsheets can be very large, pushing Excel to the limit. 
Kevin F. 


Send your SAS questions to Miss Sassy! 


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

Automating Projects


When we do project work, especially when doing conversions, we are often doing the same operation over and over again.  Quite often these tasks are done manually and take a lot of time and resources.  But these repetitive tasks can typically be automated.



The SAS SQL Procedure

Lunch & Learn Webinar


On July 12th, SSC had our first Lunch & Learn webinar featuring Steven First, President of SSC. For those of you that were unable to attend this event, or had trouble logging into GotoWebinar, we have included the recorded session and link to the presentation for you to see. The next Lunch & Learn, Principles of Good System Design, is scheduled for August 16th. You can register here.



Presentation Slides


SQL Webinar


Quickly Understand Your Data in SAS Enterprise Guide
Click to Read More

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




Check us out at MWSUG!


September 16-18, 2012

Minneapolis, MN



Using Enterprise Guide Effectively

Thomas Miron

 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.