|
Richard.Simhon@cornhill.co.uk wrote:
>
> Kevin,
>
> If the cells in excel are formated as text then the following code will do
> the job
>
> data test;
> var="00123";
> var= '='||trim(var);
> run;
>
> filename data dde "excel|sheet2!r5c3:r5c3";
> data _null_;
> file data;
> set test;
> put var;
> run;
>
> Hope this helps
>
> Richard Simhon
> Business Analyst
> Allianz Cornhill
> Tel 01483 55 2628
>
Richard,
This did not work. However, you did shed some light on the subject.
The following put the value ="00123" which appeared as 00123 in the
cell:
filename data dde "excel|sheet2!r5c3:r5c3";
data _null_;
var='="00123"';
file data;
put var;
run;
This will provide me a solution, but shouldn't SAS be able write a
formatted value, such as z5. to Excel using DDE? It seems perhaps not,
at least using v8.2 and Excel 95.
Thanks,
Kevin
--------------------------------
Kevin Viel
Department of Epidemiology
Rollins School of Public Health
Emory University
Atlanta, GA 30322
| 
