I was trying to delete png files (500000+) using systask command in a do loop. My loop stops in the 6482 loop count. Is there any reason or limit set in the loop while deleting the files this way. %MACRO LOOP; PROC SQL; create table DSNAME as SELECT distinct memname FROM DICTIONARY.COLUMNS WHERE UPCASE(LIBNAME)="WORK" AND UPCASE(MEMNAME)LIKE "FINAL_SPLIT%"; select count(*) into :datasetcnt from DSNAME; QUIT; %put &datasetcnt.; %do p=1 %to &datasetcnt.; DATA _null_; SET FINAL_SPLIT_&p.; CALL SYMPUT( "FN" || LEFT(TRIM(_N_)) , trim(file_name) ); CALL SYMPUT( "totcnt",_N_ ); run; /*%put &fn1.;*/ libname mylib &clrfold.; %do i = 1 %to &totcnt.; %let path=%sysfunc(pathname(mylib)); systask command "del ""&path.\&&fn&i..""" wait taskname="deleting"; %end; %end; %MEND LOOP; %LOOP; run;
... View more