PROC EXPORT stalls

arbnmedic33 — Wed, 25 May 2022 12:42:17 GMT

I have the following program, which runs fine until it gets to the 3rd export file (Toexport3) and any other files after that. It exports Toexport1 and Toexport2 and creates the resulting excel files for both, but stalls at Toexport3.

DATA A; INFILE 'C:\Users\ra\Documents\My SAS Files\SAS 9.4 Data\text\pdt_output_trimmed.txt' 
	TRUNCOVER FIRSTOBS = 2;
input	@1	NIIN $9.	
	@11	PLANT $4.	
	@16     SLOC $4.	
	@20     PDT $3.	
;
RUN;

DATA B; SET A; if PLANT = '2001';
	RENAME NIIN = niin PLANT = plant SLOC = sloc PDT = replen2;
	PROC SORT DATA = B; BY sloc NIIN;
RUN;

proc freq data=B;
  tables sloc / noprint out=counts ;
run;

data groups;
   if eof then call symputx('ngroups',group);
   set counts end=eof;
   retain group 0 running_count 0;
   if count + running_count > 500000 then do;
      group+1;
      running_count=0;
   end;
   running_count+count;
run;


%macro rep();
  %do i=1 %to &ngroups.;
  	data grp;
  		 set groups;
  		 if group=&i;
 
  		 proc sort data=b;
  		 	 by sloc;
  		 proc sort data=grp;
  		 	by sloc;
  		 	
  		 	data toexport&i;
  		 		merge b(in=a) grp(keep=sloc in=b);
  		 		by sloc;
  		 		if a and b;
  
       proc export data=toexport&i 
       	outfile="C:\Users\ra\Documents\My SAS Files\SAS 9.4 Output\pdt_input&i..xlsx"
       	dbms=xlsx;
  
%end; 	

%mend;

%rep;

Why would the PROC EXPORT execute through the first two outputs but stall at the 3rd and any subsequent files after that? There are 1.9M records in the input file, I'm only getting 1.4M out (up to the point where it stalls). The export data must be in excel due to the requirements of the system it is going into.

Any assistance is greatly appreciated.

Re: PROC EXPORT stalls

Tom — Wed, 25 May 2022 12:51:05 GMT

Are you sure it is not just waiting for you to submit the RUN; statement to mark the end of the second PROC EXPORT step?

You seem to have inserted an unneeded RUN: statement after your first DATA step, but left off the RUN: statement from some other steps in your code.

Re: PROC EXPORT stalls

arbnmedic33 — Wed, 25 May 2022 13:04:00 GMT

Occam strikes again...added a RUN; at the end of the macro, prior to the %end.
Fixed...thanks.

Bob

topic PROC EXPORT stalls in SAS Programming

PROC EXPORT stalls

Re: PROC EXPORT stalls

Re: PROC EXPORT stalls