topic Re: Format in SAS Programming

Format

Abdulhamid — Wed, 24 Jan 2024 14:06:16 GMT

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 €

Re: Format

FreelanceReinh — Wed, 24 Jan 2024 14:38:36 GMT

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.)

Re: Format

PaigeMiller — Wed, 24 Jan 2024 14:46:03 GMT

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

Re: Format

Abdulhamid — Sun, 28 Jan 2024 17:23:12 GMT

Thanks a lot!

Re: Format

Abdulhamid — Sun, 28 Jan 2024 17:23:42 GMT

Thank You very munch!