topic Re: Format numeric variable to seperate thousands with a space. in SAS Procedures

Format numeric variable to seperate thousands with a space.

nicnad — Wed, 12 Dec 2012 22:45:24 GMT

Hi,

I have numeric variable that are formated like the following:

format Montant 20.;

What is the proper way to format this variable so that thousands are separated with a space?

art297 — Wed, 12 Dec 2012 23:25:15 GMT

Just curious: where is that used? There are a couple of formats that separate thousands with either periods or commas.

ballardw — Wed, 12 Dec 2012 23:47:50 GMT

Won't claim this is proper but seems to work for me:

proc format library=work;

picture mysep

0 - 9999999 = '000 000 000.00' (decsep='.' dig3sep=' ') ;

run;

data _null_;

x= 123456;

put x= mysep.;

run;

TomKari — Thu, 13 Dec 2012 16:23:02 GMT

This is handled by the SAS National Language Support routines. Your locale should be "French_Canada".

Give this a try:

options locale=French_Canada;

data _null_;

Montant=123456789;

format Montant nlnum20.2;

put Montant;

run;

nicnad — Thu, 13 Dec 2012 16:28:54 GMT

It is used by french canadian.

nicnad — Thu, 13 Dec 2012 16:29:45 GMT

Works Great! Thank you very much.

Quick question, can I put at the very top of my code and it will be used in each data procedure?

art297 — Thu, 13 Dec 2012 17:06:29 GMT

You could always just put it in either your config or autoexec file. That way it will be used every time you run SAS.