FALL 2011
TECHIE TIPS
User Profile: Christopher Battiston
Read.
SAS Insturctor Tip: Charu Shankar Read.
Have you changed companies? Do you want to modify your contact preferences? Don’t forget to update your SAS profile!
For details on all of SAS' products and solutions, click here.
The SAScom blog: http://blogs.sas.com/sascom/
SAS Canada
 
Name: Bryan K. Beverly
Program Name: COMPRESS_IT 
Company: BAE Systems IT

This program creates a reduced version of an existing SAS dataset by:

  1. compressing character variables            
  2. reusing the space made available from the character compression
  3. minimizing the amount of internal storage allocated for numeric variables in the length statement

The user also has the option of using the macro language debugging options to confirm the intended resolution of the macro variables supplied by the program or added by the user.  Two Proc Contents statements allow the user to assess the impact of the reduction processing.

PLEASE NOTE! - If the existing SAS dataset has been sorted, then the reduced dataset will have same sort order, but the Proc Contents will present the reduced dataset as not sorted.
 
If the existing SAS dataset has been indexed, then the reduced dataset will not automatically indexed. To add an index to the reduced dataset, the user must supply the information needed in the INDEX parameter or add an index to the dataset after the reduction processing has been completed.    

Download the program code (PDF).

SAS and all other SAS Institute Inc. product or service names are registered trademarks \or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies. Copyright © 2009, SAS Institute Inc. All rights reserved.
P