Format

[Abdulhamid]

Hi every one ,How can I in SQL format the Amount Variables to get the Results in Euro Currency with the Thousands Groups in the Number the result should look like 123.456.789,12 €

[FreelanceReinh · Accepted solution]

Hi @Abdulhamid,

Try the NLMNLEURw. format:

proc sql;
create table test (amount1 num, amount2 num);
insert into test values (123456789.12, -987654321.09);
select amount1 format=nlmnleur21.,
       amount2 format=nlmnleur21.
from test;
quit;

(But note the LOCALE dependency mentioned in the documentation.)

[Abdulhamid]

Thanks a lot!

[PaigeMiller]

Use the NLMNLEUR format: https://documentation.sas.com/doc/en/pgmmvacdc/9.4/leforinforref/n0l3wy6df1ijdjn1r7q7i8hr6yhu.htm

[Abdulhamid]

Thank You very munch!