topic rayRe: Format for % and European Decimal convention in SAS Programming

Format for % and European Decimal convention

Cannon3006 — Wed, 04 Nov 2020 14:34:42 GMT

Hi,

I'm trying to convert numbers such as 32.5 to 32,5% using a format.

Below is the link to the format which adds the % symbol but I can't seem to find one which converts it to European decimal convention as well.

https://support.sas.com/kb/38/001.html

Thanks,

Mladen

Re: Format for % and European Decimal convention

PeterClemmensen — Wed, 04 Nov 2020 14:46:48 GMT

I don't think such a format exists. though you can roll out your own doing something like this


proc format;
   picture fmt other = '09,9%' (mult=10);
run;

data test;
   a = 32.5;
   format a fmt.;
run;

Re: Format for % and European Decimal convention

Cannon3006 — Wed, 04 Nov 2020 15:45:34 GMT

Thanks that's exactly what I was looking for.

rayRe: Format for % and European Decimal convention

Ksharp — Thu, 05 Nov 2020 13:15:42 GMT

Draycut,

What if there are two or more digit after decimal ?

proc format;
   picture fmt other = '09,99%' (decsep=',');
run;

data test;
   a = 32.5;output;
   a = 32.55;output;
   format a fmt.;
run;

Re: rayRe: Format for % and European Decimal convention

Cannon3006 — Wed, 03 Feb 2021 16:02:26 GMT

This worked great for me also. Is it possible to combine decsep and mult, to convert 0.325 to 32,5%. The code below did not work.

proc format;
   picture fmt other = '09,99%' (decsep=',' mult=100);
run;

However I did get it working using the method from the answer, I just wanted to know why mult and decsep did not work together.

proc format;
   picture fmt other = '009,99%' (mult=10000);
run;

Re: rayRe: Format for % and European Decimal convention

Ksharp — Thu, 04 Feb 2021 11:54:58 GMT

You want this ?

proc format;
   picture fmt other = '09,99%' (decsep=',' multi=10000 );
run;

data test;
   a = .325;output;
   a = .326;output;
   format a fmt.;
run;

Re: rayRe: Format for % and European Decimal convention

Cannon3006 — Tue, 09 Feb 2021 10:29:10 GMT

Yes, but that format works even without decsep=',' .The decsep seems to only work without the multiplication option. I was just curious why.

Re: rayRe: Format for % and European Decimal convention

Ksharp — Tue, 09 Feb 2021 10:42:18 GMT

No. That is different .
if without decsep=',' then
a = .325 multiply 10000 --> 3250 and insert comma at the last two position. --> 32,50

if with decsep=',' then
a = .325; --> .00325 (due to '09,99' with decsep=',') and multiply 10000. --> 32.5