numeric format change

[PierreYvesILY]

dear SAS experts,

I want to save a numeric data under a format like : 111.222.020,33 in a macrovariable in order to use it in a sentence in an email afterwards.

The original format of the variable 'Volumen' is: 111222020.33 and I want : 111.222.020,33

I tried the following, but it didn't work. What should I change?

data Ergebnis4;

set Ergebnis3;

format Volumen numx17.2;

call symput('Volumen', Volumen);

run;

%put &Volumen.;

regards

[PaigeMiller · Accepted solution]

I think you want the COMMAX. format.

data _null_;
set Ergebnis3;
call symputx('Volumen', put(Volumen,commax16.2));
run;

[PierreYvesILY]

thank you Paige, it worked exactly as I wanted!

[ed_sas_member]

HI @PierreYvesILY 

You can use the following format ("semi-french"):

data Ergebnis4;
	volumen = 111222020.33;
	call symput('Volumen', put(Volumen,commax17.2));
run;
%put &Volumen.;

[Astounding]

If you want all 17 characters  (including leading blanks) in your macro variable, use:

data Ergebnis4;
  set Ergebnis3;
  call symput('Volumen', put(Volumen, numx17.2));
run;

If you want to get rid of the leading blanks, switch from SYMPUT to SYMPUTX.

[PierreYvesILY]

thanks a lot, I didn't know SYMPUTX yet