Hello Sas-Users,

I want to use the Sas DDE in order to put some Sas variable into an
Excel Sheet.

But unfortunately, I have a variable refering to a french amount
(blanck). I don't know how to display the variables in the sheet
correctly (program below).

Thanks for your help.

Ash007.

proc format;
	picture euroblan
		-999999999 -<0  =3D '000 000 009,99 =80' (prefix =3D '-' decsep =3D ',')
		0 - 999999999   =3D '000 000 009,99 =80' (decsep =3D ',')
	;
run;

data remplace_point;
	format mnt euroblan.;
	mnt =3D 777777.77;
	x =3D "inc0";
	y =3D "inc1";
run;

options noxwait noxsync;
X '"C:\Users\Ash_Rmy\Documents\02-Pgm_sas______________\Results
\Sep_Milliers.xls"';

filename write dde 'excel|C:\Users\Ash_Rmy\Documents\02-
Pgm_sas______________\Results\[Sep_Milliers.xls]Feuil1!L1C3:L1C5';

data _null_;
	file write notab;
	set remplace_point;
	put mnt x y;
run;