As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Efficient Merging: Creating Format Libraries to Save CPU Time

From sasCommunity
Jump to: navigation, search

Abstract

In my line of work, we are constantly reading in and writing out files containing millions of records and dozens of variables. It is not uncommon to receive a file containing a handful of records and be asked to merge it with multiple large files, do some data manipulation and write out the data to a new file. Programs like these tend to take a lot of CPU time and resources to run, so we are constantly looking for better ways to speed up processing time by implementing efficient SAS techniques within our code. PROC FORMAT and its user defined formatting options is one tool that can be used to do just that: SAVE TIME.

Online Materials

Efficient Merging: Creating Format Libraries to Save CPU Time

Please let me know what you think, thanks!

Contact Info

My sasCommunity Page

--ZnebT 20:07, 24 February 2011 (UTC)