out of resources

[SASPhile]

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?

[data_null__]

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?

[sbb]

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.