LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 1997, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 > > >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. > (alternate randycates > >---------- >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. > >

Back to: Top of message | Previous page | Main SAS-L page