Date: Fri, 25 May 2001 11:38:51 -0400
Reply-To: Rouslan Moukhine <rmoukhine@COSSETTE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Rouslan Moukhine <rmoukhine@COSSETTE.COM>
Subject: Re: SAS ----> Excel2000
Content-Type: text/plain; charset=ISO-8859-1
Try changing Feuil1 to Sheet1. It should work.
RM.
On Fri, 25 May 2001 17:27:05 +0200, =?iso-8859-1?Q?HALIMI_Rapha=EBl?=
<Raphael.HALIMI@GEP.FR> wrote:
>Hello SAS-Lers,
>
>I try to export my dataset from SAS v8.1 to Excel2000. And there's no error
>in the LOG !!!!!
>But I'm not writing to you because I'm only proud of it... Actually,
NOTHING
>happens in my worksheet : it remains clear.
>
>Could anyone test this code and tell me what happens ? (Note : the name of
>the Excel sheet is "Feuil1" for me)
>
>FILENAME ddedata DDE 'excel|Feuil1!r1c1:r100c3'; /* Feuil1 -> Sheet1 for
>american release */
>
> DATA e;
> FILE ddedata;
> DO i = 1 TO 100;
> x = RANUNI(i);
> y = 10 + x;
> z = x - 10;
> PUT x y z;
> END;
> RUN;
>
>
>Thanks for any help !
>
>Raphaël
|