topic How to create numeric values with ,00? in SAS Programming

How to create numeric values with ,00?

Hansmuffs — Thu, 11 Feb 2021 10:32:14 GMT

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 — Thu, 11 Feb 2021 10:42:33 GMT

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

Hansmuffs — Thu, 11 Feb 2021 10:50:32 GMT

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 — Thu, 11 Feb 2021 10:54:22 GMT

Ok then do this

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