topic Re: format percent with comma in SAS Programming

format percent with comma

mariopellegrini — Mon, 08 Feb 2021 09:27:53 GMT

Good morning.
I would like to know if it is possible to display a percent format with a comma. Like this for example: 12,5% and not 12.5%
The percentw.d format always displays the period, not the comma.
Thank you

Re: format percent with comma

PeterClemmensen — Mon, 08 Feb 2021 09:40:53 GMT

I don't think it exists out-the-box. Though, you can always roll out your own like this

proc format;
   picture PercentC low-high = '000.009,9%' (multiplier = 1000);
run;

data _null_;
   a = 0.125;
   put a = PercentC.;
run;

Re: format percent with comma

mariopellegrini — Mon, 08 Feb 2021 09:43:13 GMT

I am interested in the format, not informat. I would visualize on the table 12,5% with comma

Re: format percent with comma

PeterClemmensen — Mon, 08 Feb 2021 09:45:48 GMT

That's exactly what my code does?

Re: format percent with comma

mariopellegrini — Mon, 08 Feb 2021 09:55:12 GMT

@PeterClemmensen thank you. It's correct. How do I increase a decimal?

Re: format percent with comma

FreelanceReinh — Mon, 08 Feb 2021 10:11:30 GMT

Hello @mariopellegrini,

You can also use the NLPCTw.d format:

options locale=IT_IT; /* This might be your default value. */

data _null_;
input p q;
put p nlpct6.1 q nlpct8.2;
cards;
0.125 -0.125
1      1.5678
;

Result:

 12,5% -12,50%
100,0% 156,78%

Re: format percent with comma

Ksharp — Mon, 08 Feb 2021 10:54:37 GMT

proc format;
   picture PercentC low-high = '009,999%' (decsep=',' multiplier = 100000);
run;

data _null_;
   a = 0.125;
   put a = PercentC.;
run;