topic Re: PUT(var, FORMAT) not working? in SAS Enterprise Guide

PUT(var, FORMAT) not working?

dirks — Thu, 15 Sep 2016 12:03:00 GMT

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?

RW9 — Thu, 15 Sep 2016 12:08:51 GMT

Have a look at the Documentation:

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.

Kurt_Bremser — Thu, 15 Sep 2016 12:11:18 GMT

Look if the COMMAX format does what you want.

dirks — Thu, 15 Sep 2016 12:12:12 GMT

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