I m using this expression in the query builder task of EG 9.1:
PUT(t1.OpRevenue, COMMA8.2)
OpRevenue is "10.5" and I need "10,5".
According to the documentation, this should be the way how it is done, but it is not working.
I still get "10.5".
What am I doing wrong?
Look if the COMMAX format does what you want.
Have a look at the Documentation:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000200667.htm
It states that the comma format applies a comma after each block of three in the whole part of the number. It doesn't replace dot with comma.
You could of course do:
tranwrd(put(t1.oprevenue,8.2),".",",")
I don't know of a format offhand which treats numbers using the comma notation.
I think I was missinterpreting something. I guess COMMAX8.2 will do it! Thanks!
Look if the COMMAX format does what you want.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.