DATA Step, Macro, Functions and more

out of resources

Reply
Super Contributor
Posts: 648

out of resources

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?
Respected Advisor
Posts: 3,777

Re: out of resources

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: out of resources

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.
Ask a Question
Discussion stats
  • 2 replies
  • 98 views
  • 0 likes
  • 3 in conversation