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 (October 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sat, 25 Oct 2008 04:50:07 -0700
Reply-To:     Zakaria <zalazhar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Zakaria <zalazhar@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: dde excel not updating
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Howard,

It works for me too at home, having sas 9 and excel 2003. But at work I don't see the values written to the spreadsheet. The log doesn't give any errors. In contrary it says the values are written. Maybe there is a setting that I have to change. Here is the log :

NOTE: The file TEST is: DDE Session, SESSION=excel|[Analyse Movir Sjabloon.xls]uitvoer!r1c1:r1c1, RECFM=V,LRECL=256

NOTE: The file TEST1 is: DDE Session, SESSION=excel|[Analyse Movir Sjabloon.xls]uitvoer!r2c1:r2c3, RECFM=V,LRECL=256

NOTE: 1 record was written to the file TEST. The minimum record length was 7. The maximum record length was 7. NOTE: 1 record was written to the file TEST1. The minimum record length was 3. The maximum record length was 3. NOTE: There were 1 observations read from the data set WORK.PRICE_LIST. NOTE: DATA statement used (Total process time): real time 2.46 seconds cpu time 0.00 seconds

NOTE: The file TEST is: DDE Session, SESSION=excel|[Analyse Movir Sjabloon.xls]uitvoer!r1c1:r1c1, RECFM=V,LRECL=256

NOTE: The file TEST1 is: DDE Session, SESSION=excel|[Analyse Movir Sjabloon.xls]uitvoer!r2c1:r2c3, RECFM=V,LRECL=256

NOTE: 1 record was written to the file TEST. The minimum record length was 7. The maximum record length was 7. NOTE: 1 record was written to the file TEST1. The minimum record length was 3. The maximum record length was 3. NOTE: There were 1 observations read from the data set WORK.PRICE_LIST. NOTE: DATA statement used (Total process time): real time 2.46 seconds cpu time 0.00 seconds

On 24 okt, 22:27, hs AT dc-sug DOT org ("Howard Schreier" wrote: > On Fri, 24 Oct 2008 15:45:04 -0400, Zakaria al Azhar <alazh...@HOTMAIL.COM> > wrote: > > > > >Hi all, > > >I'm expirementing with dde to update a spreadsheet with data from SAS. > >Somehow the data is not written to the spreadsheet, even the log says so. I > >have SAS 8 and excel 2002, using the following code: > >libname bron 'd:\weggooi'; > > >libname bron 'H:\Bronnenanalyse'; > > >/******************************************* > > >Fire up MS Excel, method 2 by Chris Roper. > > >*******************************************/ > > >options noxsync noxwait; > > >filename sas2xl dde 'excel|system'; > > >data _null_; > > >length fid rc start stop time 8; > > >fid=fopen('sas2xl','s'); > > >if (fid le 0) then do; > > >rc=system('start excel'); > > >start=datetime(); > > >stop=start+10; > > >do while (fid le 0); > > >fid=fopen('sas2xl','s'); > > >time=datetime(); > > >if (time ge stop) then fid=1; > > >end; > > >end; > > >rc=fclose(fid); > > >run; > > >/********************************* > > >Open an existing Excel workbook: > > >'existing workbook.xls' > > >*********************************/ > > >data _null_; > > >file sas2xl; > >put '[open("h:\bronnenanalyse\Analyse Movir Sjabloon.xls")]'; > > >run; > > >filename > >test > >dde > >'excel|[Analyse Movir Sjabloon.xls]uitvoer!r1c1:r1c1' > >notab; > > >data _null_; > > >set bron.verloop_beroep_mov; > > >file test; > > >put kode_ber; > > >run; > > Worked OK for me after appropriate substitutions. Please post relevant parts > of the log.


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