Hello,
This morning I've got the following error in EG 4.3. Yesterday the same code did not produce any errors. I put the trouble code into separate project with the same error result. The LOG and error is below:
17 proc SQL;
18 create table d_MTR as
19 select a.*,
20 case
21 when a.DR_InsuranceType in (0,1) then "Ins "
22 when a.DR_InsuranceType in (2) then "UnIns"
23 else "Unk "
24 end as Ins,
25 case
26 when a.DR_ProductID in (18411,18412,18413,18421,18422,
27 18423,18431,18432) then 0 /* Nonconfirming */
28 else 1 /* Confirming */
29 end as conf label="1-Conf, 0-NonConf"
30 from _l.LGD_MTR_SEP00_NOV10_N_SZ_110211_ as a
31 left join _b.uvw_OrigBeacon_MTR as b on a.AccountID=b.AccountID
32 where a.YearMonth=a.DISC_YYYYMM
33 ;
ERROR: CLI open cursor error: ERROR: reserve exceeded : Out of memory
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
33 ! quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.65 seconds
cpu time 0.01 seconds
Sincerely,
SPR