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 (July 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sat, 12 Jul 2003 13:44:36 +0100
Reply-To:     Crawford <PeterDOTCrawfordATblueyonder.co.uk@Peter.BITNET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Crawford <PeterDOTCrawfordATblueyonder.co.uk@Peter.BITNET>
Organization: blueyonder (post doesn't reflect views of blueyonder)
Subject:      Re: DDE

there is a syntax problem with the Save.as command In the archives, See http://groups.google.com/groups?q=dde+save.as+group:comp.soft-sys.sas&hl=en&lr=&ie=UTF-8&scoring=G&selm=4B3822B43D03D311A6050000F68ABFE7B77504%40dshsbudland.dshs.wa.gov&rnum=1

"David Schwartz" <david_schwarz@SRA.COM> wrote in message news:200307111455.h6BEtRF21411@listserv.cc.uga.edu... > I have been submitting the following: > > options noxwait noxsync symbolgen mtrace mlogic mprint msglevel=i; > x 'C:\Progra~1\Micros~1\Office10\excel.exe'; > > so that I can submit commands to Excel from within SAS as in the following: > > filename cmds dde 'EXCEL|SYSTEM'; > data _null_; > x = sleep(10); > run; > data _null_; > %let path=c:\report_&st..xls; > file cmds; > put "[Save.as(&path)]"; > put "[File.Close()]"; > put '[QUIT()]'; > run; > > The result is the following error: > > ERROR: Physical file does not exist, EXCEL|SYSTEM. > NOTE: The SAS System stopped processing this step because of errors. > NOTE: DATA statement used: > real time 0.00 seconds > cpu time 0.00 seconds > > I have checked, and the 'Ignore other applications' box in Excel is not > checked. Any other ideas on what the problem might be? > > DLS


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