topic Re: out of resources in SAS Programming

out of resources

SASPhile — Sat, 14 Feb 2009 19:08:55 GMT

I'm trying a set statement on files. each of them have 30k or more observations.
when i run the following code i'm getting an error "out of resources:.
%macro mrge_plan;
data ctm_comb.flip_plan_files;
set
%do i= 1 %to 9;
flip08.flip_plan_%sysfunc(putn(&i,z2.))

%end;;

run;
%mend mrge_plan;
%mrge_plan;

how to handle this error?

Re: out of resources

data_null__ — Sat, 14 Feb 2009 19:15:10 GMT

Perhaps open=defer SET statement option will work for you if the variable in FILP_PLAN_nn are all the same. See doc for details.

> I'm trying a set statement on files. each of them
> have 30k or more observations.
> when i run the following code i'm getting an error
> "out of resources:.
> %macro mrge_plan;
> data ctm_comb.flip_plan_files;
> set
> %do i= 1 %to 9;
> flip08.flip_plan_%sysfunc(putn(&i,z2.))
>
> %end; open=defer;
>
> run;
> %mend mrge_plan;
> %mrge_plan;
>
> how to handle this error?

Re: out of resources

sbb — Mon, 16 Feb 2009 13:11:30 GMT

Send more info - SAS version, OS platform, and also send SASLOG output (with all SOURCE code revealed) about the problem leading up to the error. Also, have you tried your code with fewer than 9 files -- at what point does the error start to occur? The SAS support website http://support.sas.com/ reveals that there are multiple possible contributing factors to this type of error message, disk space, memory, SAS CONFIG options, amount of system memory, and others.

Scott Barry
SBBWorks, Inc.