08-20-2013 04:35 AM
In a file I receive amount is presented like below (with currency) and therefore is character.
With the locale option and this new informat I manage to read it in correctly.
But . . . is there a way to also automatically detect the currency value (now it is EUR but it can be anything)
I use now some character functions, but perhaps it can be neater !!
options locale=Dutch_Belgium ;
format balance commax25.2 ;