topic converting decimal period seperators to comma seperators in SAS Programming

converting decimal period seperators to comma seperators

Anita_n — Tue, 12 Jan 2021 10:41:34 GMT

Dear all,

I have a question I have a dataset exported from postgresql and there are columns containing whole numbers as well as decimal numbers. The decimals numbers are seperated with periods (e.g. 0.166)

and the whole numbers are like 50, 75, 100 etc. These values are imported into SAS with format best12. I wish to change the period to comma like 0.166 should be 0,166

I tried using this code:

option locale = de_DE;
data xyz;
data want;
format ab commax7.2;
run;

That works well, my question is, is it possible to make SAS only set the decimal numbers to 2 decimal places? The whole numbers like 50, 75 should not be written as 50,00 or 75,00

I guess this is not possible but there might be a way to work around this.

The column should remain like in the original data only the period should be replaced with a comma

Thanks

Re: converting decimal period seperators to comma seperators

PaigeMiller — Tue, 12 Jan 2021 12:21:47 GMT

If you want to use PROC REPORT to create an output table with these formats, yes it is possible.

I think you can also use PROC FCMP to create a function used as a format, see https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=p1gg77jyhc9s42n1f1vjyx2hsg8b.htm&locale=en

Re: converting decimal period seperators to comma seperators

Ksharp — Tue, 12 Jan 2021 12:33:05 GMT

proc fcmp outlib=work.func.math;
function x(x) $;
 length result $ 40;
 if mod(x,1)=0 then result=left(put(x,best32.));
  else result=left(put(x,commax32.2 ));
  return (result);
endsub;
run;

options cmplib=work.func;
proc format ;
picture fmt
low-high=[x()];
run;

data x;
input x;
format x fmt10.;
cards;
73.21
65
;

I am not sure I understood what you are looking for.