topic Re: Numeric format with decimal comma in SAS Programming

Numeric format with decimal comma

VojtechHerrmann — Tue, 21 Feb 2017 16:17:40 GMT

Hi,

is there any SAS numeric format, that would return these outputs from these inputs:
INPUT: 1 --- OUTPUT: 1
INPUT: 1.1 --- OUTPUT: 1,1
INPUT: 1.1235 --- OUTPUT: 1,1235

?

Basically: I need some format with decimal comma, but the only one I have found is NUMXw.d. However that gives 1,0000 out of 1. Which is what I dont want.

Many thanks in advance,
V.Herrmann

Re: Numeric format with decimal comma

mbuchecker — Tue, 21 Feb 2017 18:09:57 GMT

I think you want COMMAXw.d

Re: Numeric format with decimal comma

ChrisNZ — Tue, 21 Feb 2017 22:19:24 GMT

No format does this afaik. bestx shoud but doesn't.

If you really need a format, you can build it:


proc fcmp outlib=WORK.FUNCTIONS.TEMP; 
  function bestxx (NUMBER) $ ;
    return (translate(cat(NUMBER),',','.'));
  endsub;
run;

options cmplib= WORK.FUNCTIONS;    
proc format;
  value bestxx other=[bestxx()];
run;
 
data _null_;
  A= 1      ;put A= @11 A= bestxx.; 
  A= 1.1    ;put A= @11 A= bestxx.; 
  A= 1.1235 ;put A= @11 A= bestxx.; 
run;

A=1 A=1
A=1.1 A=1,1
A=1.1235 A=1,1235

Re: Numeric format with decimal comma

VojtechHerrmann — Wed, 22 Feb 2017 09:20:35 GMT

Thank you for your response!

V.Herrmann