BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dirks
Quartz | Level 8

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?

1 ACCEPTED SOLUTION
3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

dirks
Quartz | Level 8

I think I was missinterpreting something. I guess COMMAX8.2 will do it! Thanks!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1709 views
  • 0 likes
  • 3 in conversation