Help using Base SAS procedures

alternative to proc format

Reply
N/A
Posts: 0

alternative to proc format

We use a huge set ( about 3000) of formats using proc format. This is done with proc format; value; syntax. I some how feel this is increasing the run time of the program. Is there an alternative way to do this?
Super Contributor
Posts: 359

Re: alternative to proc format

Rather than trying to explain it here is a paper showing how to use a dataset to create formats.
http://www2.sas.com/proceedings/forum2007/068-2007.pdf
Super Contributor
Super Contributor
Posts: 3,174

Re: alternative to proc format

It's unclear whether the PROC FORMAT execution is what you feel is "increasing the run time" or whether using the SAS formats in your DATA step code is where you have concern for run time.

I don't expect you will see significant run time improvements with using the CNTLIN= approach, however that approach will make it much easier to maintain your input/output data values used with these formats.

You can analyze your SAS execution time easily by not executing the PROC FORMAT code, and setting the NOFMTERR option to experiment. Review the SAS log information for DATA and PROC step execution times.

Scott Barry
SBBWorks, Inc.
Respected Advisor
Posts: 3,777

Re: alternative to proc format

Why don't you create a permanent format library. It "sounds" like you are running the PROC FORMAT code in each job possibly, via %INC. but the point is you don't need to do it that way. A library would be more efficient.
Ask a Question
Discussion stats
  • 3 replies
  • 123 views
  • 0 likes
  • 4 in conversation