We are still helping our customers get more out of the data they have and make data driven decisions. Our new site is packed with information and insights of how data can be the catalyst to your business growth.
A very efficient way of defining Formats and Informats is to use an Input Control Data Set with Proc Format, rather than writing VALUE or INVALUE statements.
For example, suppose you have the following data set and you wish to create a simple numeric format to convert outlet codes into their actual names:
Create the Input Control Data Set with the variables START, LABEL and FMTNAME. Then run a Proc Format step which points to the CNTLIN data set as follows.
data work.outfmt(keep=start label fmtname);
set work.outlets(rename=(outcode=start outname=label));
proc format library=work cntlin=work.outfmt;
335 proc format library=work cntlin=work.outfmt;
NOTE: Format OUTFMT has been output.
This technique is particularly useful when formats need to be created dynamically at run time.