Systems Seminar Consultants, Inc.
The Missing Semicolon
Volume 13 Number 4                      Subscribe Here! April / 2012

The SAS® Log: A Wealth of Data and Job Flow Information  


There have been many programs and papers written about reading the SAS® log for error checking and warnings. Although that information is valuable, we have found that the data messages that include filenames, row counts, and other information are a wonderful source of run-time metrics. This is where the real value of the SAS log is. These metrics, along with metrics provided by PROC SCAPROC, can be used to automate and validate run results, debug errors, provide job flow information and job optimization, and enable grids. This paper discusses the jobs that we have developed to use this neglected source of information.


Read More

Filtering Data in SAS Enterprise Guide


This article discusses one of the basic processes used in most projects, sub-setting SAS datasets.  This can be done in Enterprise Guide in multiple ways. This article shows both the 'Filter and Sort' task and 'Query Builder.' It also includes examples using character variables, numeric variable, and date variables.

Setting Print Options in Enterprise Guide
Click to Read More


Foundation Training



Introduction to SAS

May 14-16


Enterprise Guide

May 17-18


Sign up Here! 



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


Dear SAS User,



The SAS World is very fast paced, and it seems that SAS is always coming out with new versions that have exciting new functionality.  Sometimes you may also discover that you would benefit from using SAS on a different platform.  In both of these cases, it means that it is time for your organization to do an upgrade or conversion.


Oftentimes, the upgrades to new versions can go very smoothly.  However, there are small things that need to be addressed ahead of time to prevent larger problems.  With conversions to new platforms, it is also very important to plan ahead for differences.  For example, how does Windows store data differently from UNIX?


We have done many upgrades and conversions over the years, and with the computing power now available in PC's, many of our clients are asking for help with moving their SAS environment to Windows.  We have come up with many automated tools that can do a lot of the heavy lifting of conversions-for the actual changes, the testing, and the final audit.


If you are considering an upgrade or conversion, do your homework up front, consider what processes may be automated, and make sure that you have a thorough testing process for a successful migration.



Thanks for Reading!

Jennifer First
Director of Operations  



Intro to SAS®

May 14-16 | September 17-19
SAS Enterprise Guide®
May 17-18 | September 20-21
SAS®  Macros
September 24-25
SAS® SQL Procedure
September 27
SAS® Efficiencies
September 28

If someone signs up for a class and refers your name, receive 25% off your next class!
Calculating the Next Sequential Number and Storing it for Later Use
Click to Read More

Start Thinking About Fall Training!

Fall Schedule and Registration


Foundation Courses

SAS Enterprise Guide, 

Introduction to SAS, The SAS SQL Procedure


Report Writing Courses

SAS Report Writing, Proc Report, Exploiting SAS ODS


Advanced Topics

SAS Tips & Tricks, Advanced SAS, Efficiencies, SAS Macros, Advanced SAS Macros



 Early Bird Special!


Sign up for a fall intro class by June 30th and receive $200 off! 


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.