Numeric format with decimal comma

[VojtechHerrmann]

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

[mbuchecker]

I think you want COMMAXw.d

[ChrisNZ · Accepted solution]

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

[VojtechHerrmann]

Thank you for your response!

V.Herrmann