topic numeric format change in New SAS User

numeric format change

PierreYvesILY — Tue, 03 Mar 2020 16:26:37 GMT

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 — Tue, 03 Mar 2020 16:33:13 GMT

I think you want the COMMAX. format.

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

ed_sas_member — Tue, 03 Mar 2020 16:33:23 GMT

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


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

Astounding — Tue, 03 Mar 2020 16:35:16 GMT

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 — Tue, 03 Mar 2020 16:45:34 GMT

thanks a lot, I didn't know SYMPUTX yet

PierreYvesILY — Tue, 03 Mar 2020 16:46:41 GMT

thank you Paige, it worked exactly as I wanted!