Date:         Tue, 21 Jan 1997 10:52:49 -0500
Reply-To:     Toland_G <Toland_G@DCGATE.BLS.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Toland_G <Toland_G@DCGATE.BLS.GOV>
Subject:      Re: SAS TO EXCEL
Comments: cc: Sallee <Sallee_Bondad@NOTES.TOYOTA.COM>
Content-Type: text/plain; charset="us-ascii"

If you are using Excel 7.0 you will find your answer at
>http://www.sas.com/service/techsup/unotes/V6/C138.html
>
>There is different syntax using DDE with Excel when using Version 7.0.  Good
>Luck.
>
>Gregory J Toland
>Bureau of Labor Statistics
>Office of Compensation & Working Conditions
>Statistical Methods Group
>202-606-6133
>
>GO REDSOX CELTICS BRUINS PATRIOTS!!!
>
>
>----------
>From:  Cates, Randall C[SMTP:rccates@MKG.COM]
>Sent:  Tuesday, January 21, 1997 10:24 AM
>To:    Multiple recipients of list SAS-L
>Subject:       Re: SAS TO EXCEL
>
>Sallee;
>
>Just a guess, but try using double quotes "" around the filename rather than
> single quotes ''.
>
>Randy Cates, SAS Consultant
>Arbor Consulting Resources Inc.
>rccates@mkg.com (alternate randycates @msn.com)
>
>----------
>From:          [SMTP:Sallee_Bondad@NOTES.TOYOTA.COM]
>Sent:  Monday, January 20, 1997 3:36 PM
>To:  Multiple recipients of list SAS-L
>Subject:  SAS TO EXCEL
>
>Sallee Bondad
>01/20/97 02:36 PM
>
>I  am trying to write to an excel file. I was able to invoke excel from sas
>but I got an error message that  says : physical file does not exist .
>HELP!!
>
>This is the program:
>
>OPTIONS NOXWAIT NOXSYNC;
>X '\\ENTNET15\APPS\OFFICE95\EXCEL\EXCEL.EXE';
>DATA _NULL_;
>X=SLEEP(30);
>RUN;
>
>DATA ONEA;
>DO I=1 TO 20;
>   X=RANUNI(I);
>   Y=X + 5;
>   Z=X/2;
>   OUTPUT;
>   END;
>RUN;
>
>FILENAME DATA DDE
>       'EXCEL|C:\MY DOCUMENTS\[BUDGET2.XLS]SHEET1!R1C1:R20C2';
>  RUN;
>
>DATA _NULL_;
>SET ONEA;
>FILE DATA NOTAB LRECL=65488;
>   PUT X '09'X  Y '09'X  Z '09'X;
>RUN;
>
>FILENAME  CMDS DDE 'EXCEL|SYSTEM';
>DATA _NULL_;
>FILE CMDS;
>PUT '[SELECT("R1C1:R20C3")]';
>PUT '[SORT(1,"R1C1")]';
>PUT '[SAVE()]';
>PUT '[QUIT()]';
>RUN;
>
>And this is the error message:
>
>ERROR: Physical file does not exist, EXCEL|C:\MY DOCUMENTS\[BUDGET2.
>XLS]SHEET1!R1C1:R20C2.
>NOTE: The SAS System stopped processing this step because of errors.
>NOTE: The DATA statement used 0.88 seconds.
>
>