Hi Tom, Try run the code and it take long time to process(1 hour waited) and still running. I stop the code running and check the log, seem it stuck at 2nd record. data new;
infile 'dir C:\Users\Desktop\testing\*.txt /s /b' pipe truncover;
length Grp_AC $11 No $16 Batch_no $14
TRX_CODE $3 Amount 8 Block_Code $4
;
input name $256. ;
file_name = scan( scan( name, -1, '\' ), 1, '.' );
infile in filevar=name end=last firstobs=11 truncover ;
do while (not last);
input Grp_AC $ 1-24 @;
if not (Grp_AC in ('Grp A' , ' ', 'OVER', 'Total Count') ) then do;
input Grp_AC $ 1-24
No $ 31-48
Batch_no $ 52-66
TRX_CODE $ 72-76
@86 Amount trailsgn16.
Block_Code $ 110-113
;
output;
end;
end;
run;
... View more
