12-12-2012 05:45 PM
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?
12-12-2012 06:25 PM
Just curious: where is that used? There are a couple of formats that separate thousands with either periods or commas.
12-12-2012 06:47 PM
Won't claim this is proper but seems to work for me:
proc format library=work;
0 - 9999999 = '000 000 000.00' (decsep='.' dig3sep=' ') ;
put x= mysep.;
12-13-2012 11:23 AM
This is handled by the SAS National Language Support routines. Your locale should be "French_Canada".
Give this a try:
format Montant nlnum20.2;
12-13-2012 11:29 AM
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?
12-13-2012 12:06 PM
You could always just put it in either your config or autoexec file. That way it will be used every time you run SAS.