/***************************************************************************************************************** SAS file name: picture_format_options File location: _________________________________________________________________________________________________________________ Purpose: To demonstrate how to enhance your picture formats with the five options Round, Prefix, Default Length, Multiplier and Noedit Option Author: Peter Clemmensen Creation Date: 18/01/2019 This program supports the example page "Five SAS Picture Format Options You Should Know" on SASnrd.com *****************************************************************************************************************/ data MyData; input num; datalines; 10.999 -100.603 0 100 1000.333 ; proc print data=MyData; run; /* Round option */ proc format; picture MyFmt (round) low-high = '000,009.9'; run; proc print data=MyData; format num MyFmt.; run; /* Defult Option */ proc format; picture MyFmt (round default=20) low-high = '000,009.9'; run; proc print data=MyData; format num MyFmt.; run; /* Prefix Option */ proc format; picture MyFmt (round default=20) low-<0 = '000,009.9' (prefix='-$') 0-high = '000,009.9' (prefix='$'); run; proc print data=MyData; format num MyFmt.; run; /* Multiplier option */ proc format; picture MyFmt (round default=20) low-<0 = '000,009.9' (prefix='DKK -' multiplier=6.5) 0-high = '000,009.9' (prefix='DKK ' multiplier=6.5); run; proc print data=MyData; format num MyFmt.; run; /* NoEdit Option */ proc format; picture MyFmt (round default=20) low-<0 = '000,009.9' (prefix='DKK -' multiplier=6.5) 0 = '-' (noedit) 0<-high = '000,009.9' (prefix='DKK ' multiplier=6.5); run; proc print data=MyData; format num MyFmt.; run;