Prev: Creating Dummy Variables from Values of Variables (reformatted to
Next: minimum value
From: ash007 on 15 Dec 2009 04:25
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 = '000 000 009,99 €' (prefix = '-' decsep = ',')
0 - 999999999 = '000 000 009,99 €' (decsep = ',')
;
run;

data remplace_point;
format mnt euroblan.;
mnt = 777777.77;
x = "inc0";
y = "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;
 | 
Pages: 1
Prev: Creating Dummy Variables from Values of Variables (reformatted to
Next: minimum value