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
... View more
