How to create numeric values with ,00?

[Hansmuffs]

Hello,

I've an xml file (it's German currency values) where column Amount ist a string column with values like this.

5,000; 4,000; 7,500

Now I have changed this from string to numeric with this statement.

New_Amount = round(input(Amount, commax32.),0.01);

My result is for the example values above is.

5; 4; 7,5

But I need these values.

5,00; 4,00; 7,50

What do I have to change?

Thank you and regards

Hans

[PeterClemmensen]

Use the Commax Format

data _null_;
   a = 7.5;
   format a commax8.2;
   put a=;
run;

[Hansmuffs]

The value a in my case is a string. This solution is not working.

data eee;
   a = '7,50000';
   format a commax8.2;
   put a=;
run;

[PeterClemmensen · Accepted solution]

Ok then do this

data eee;
   a = '7,50000';
   b = input(a, commax10.8);
   format b commax10.2;
run;