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

 

Dear SAS User,

 

We are adding in a new exciting feature to The Missing Semicolon.  It is a SAS Q&A called Dear Miss Sassy.  You can submit your most perplexing SAS questions, and your question just may be featured in our newsletter.  One of our SAS experts will provide a comprehensive answer for you.  If you are featured in the newsletter, you will also receive a complimentary gift from SSC.  Please email your questions to admin@sys-seminar.com.  We can include your name, or you can remain anonymous. 

 

We look forward to hearing from you!


 

 

Thanks for Reading!

Jennifer First
Director of Operations 

 
Dear Miss Sassy:
 
Send your SAS questions to Miss Sassy! 
 
Email: admin@sys-seminar.com, if your question is featured in a newsletter, we will send you a free gift!

Data About Data - A Look at Dictionary Tables & SASHELP Views

 

 

A component was added in SAS Version 6.07 called dictionary tables. This column will introduce you to
these interesting and useful objects in the SAS system. Dictionary tables are special read-only PROC SQL objects that contain systems catalogs for all SAS datasets and other SAS files. Some of this information is available from PROC CONTENTS, PROC DATASETS, and other sources, but dictionary tables are more readily available and are usually easier to access. Using Dictionary Tables you might use a dictionary table when you want to...

  • Know if a dataset exists, how many variables it contains, and how many observations it contains
  • Check the current value of an option or title, change it, but then reset it back to the original value when you are finished
  • Determine if a macro variable exists
  • Capture the names of variables, as well as the attributes, from a SAS data file  
     
  
Lunch & Learn at SSC!
 Click Image for Lunch & Learn Menu
 
Automated, Efficient, Innovative, Flexible Systems

 

- Design, coding, and documentation

 
- 30 years of experience in SAS and SQL
 
- SAS certified professionals 
 
- Alliance Partners of the SAS Institute
  
 
For assistance, recommendations, or quote on an upcoming project
 
Call (608) 278-9964 

Demystifying Inherited Programs

 


Have you ever inherited a program that leaves you scratching your head trying to figure it out?  If you have not, chances are that some time in the future you will.  While initially the program may work and not require any changes, this may not always be the case.  At some point the program may require maintenance due to new requirements, system upgrades, data issues, etc.  At that time it will be necessary to figure out what is really happening so you can modify the program.

 

 

Read More

 
Quick Tip: The Holiday Function
Click to Read More
News

 

 
Foundation Training

 

 

Introduction to SAS

July 16-18

 

Enterprise Guide

July 19-20

  

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

 

   

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 July 31st and receive $200 off! 

  

1-800-997-7081 or admin@sys-seminar.com for details

 

 

 
 
 
Systems Seminar Consultants | www.sys-seminar.com | 1.800.997.7081
admin@sys-seminar.com  | 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.