Dear Community,
I have data inputs, volume1 column is numeric. Sharing print and contents results.
Expected output I am looking , convert volume column with 9 decimal places and convert .(dot) with ,(comma).
I managed to fix it with below piece , like making 9 decimal places and also convert .(dot) with ,(comma) but problem it is coming with character, and I know that is obvious.
My question is - Is there any possibilities to have the values(format) with numeric, because it needs to export into xlsx, and keeping character column, xlsx does have calculation for character values.
data output1; set input1; volume = put(volume1,20.9); volume=tranwrd(volume,'.',','); run;
Xlsx, does not shows sum , because of character values.
... View more
