topic Re: Format like COMMAw.d except for spaces in SAS Procedures

Format like COMMAw.d except for spaces

Kastchei — Fri, 13 May 2011 21:03:04 GMT

I have a need to output numeric data in a format like COMMAw.d except with spaces instead of commas:

123456789.123456789

outputs as

123 456 789.123 456 789

Is there a built in SAS format for this? I can make it by creating a character variable using put(, commaw.d) and then using translate to change all the commas to spaces, but it would be nice to have a format already. Thanks!

Re: Format like COMMAw.d except for spaces

Patrick — Sat, 14 May 2011 01:11:34 GMT

proc format;
  picture pCommaN
    low -< 0 = '00 000 009.900000' (prefix='-')
    0 - high = '00 000 009.900000'
  ;
run;

options ls=120;
data _null_;
  do a= -999912.123456 to 99999999.999999 by 999912.123456 ;
    put @1 'comma15.6: ' a comma15.6 @30 'comma24.6: ' a comma17.6 @61 'pCommaN.: ' a pCommaN.;
  end;
run;

HTH
Patrick

Re: Format like COMMAw.d except for spaces

Kastchei — Wed, 18 May 2011 16:03:35 GMT

Thanks!