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>
Subject: Memory problem with SAS 8 to Excel via DDE under Windows NT
Content-Type: text/plain; charset=ISO-8859-1
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:
%do i = 1 %to 1000;
filename dane dde "Excel|[Book1]Sheet1!R1C1:R10000C3" notab;
file dane lrecl=1048576;
do i = 1 to 10000;
put 'aaa' '09'x 'bbb' '09'x 'ccc';
I am using Winows NT 4.0 (SP6) with 128 MB.