Date:         Mon, 16 Sep 2002 03:03:37 -0700
Reply-To:     Lolek <llll@INTERIA.PL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lolek <llll@INTERIA.PL>
Organization: http://groups.google.com/
Subject:      Memory problem with SAS 8 to Excel via DDE under Windows NT
Content-Type: text/plain; charset=ISO-8859-1

Hi everyone,

I am using a code that put lots of data and formatting into an Excel
spreadsheet via DDE. Everything works just fine when I do it in SAS
6.12 - the Task Managers shows that memory rises only one (1!) line up
and after the procedure finishes it goes down. But now I run the same
code in SAS 8.2 (TS2M0) and the memory rises up, up and up until this
message shows up in the log:
FATAL: Insufficient memory to execute data step program. Aborted
during the EXECUTION phase.
following by many:
ERROR: Out of memory.
The memory is still at the top when I exit Excel and close all
filenames. It goes down only when I exit SAS.
Here I wrote a code that runs out of memory at some point:



%macro aaa;
%do i = 1 %to 1000;

filename dane dde "Excel|[Book1]Sheet1!R1C1:R10000C3" notab;
data _null_;
  file dane lrecl=1048576;
  do i = 1 to 10000;
    put 'aaa' '09'x 'bbb' '09'x 'ccc';
  end;
run;
filename dane;

%end;

%mend;
%aaa;


I am using Winows NT 4.0 (SP6) with 128 MB.

--
Lolek