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.