I Am trying to read all the log files of a user to a dataset having incremental number version . Please check below example. I am SAS 9.4 , trying to extract all the log files of user1 having 17 versions into dataset chkmain. I tried below code, the iterations are working but not getting observations into dataset. Pease suggest.   %macro version(file=,ver=); data chk_lst;   %do i= 1 %to &ver ; infile "&pathname&file&i"      lrecl=900 termstr=CRLF delimiter=' ' truncover;     input f_1$1-900;     output; %end;     run;     %mend; %version(file=user1.log@@/main/,ver=17); ... View more

Hi All, I have a variable F_1 having lines as below from log. I need to create a sequence variable dynamically based on 1st occurrence value ='System name' and last occurrence value='End time'. PLease suggest.   __Report System name is XXXX-XX111111 __Report Compile Server name is xxxxxx-xx111111.yy.yyyyyy.n __Report User name is zzzz __Report Input program name is D:\zzzz1_zzz\xyz101B\xyz101B0001\rmz_1\pgr\sale\l_ae.sas@@\zxcv\0 __Report Start time is 05/06/2023:12:50:28.65 Starting remote SAS execution on xxxxxx-xx111111.yy.yyyyyy.n of l_ae.sas Running SAS l_ae.sas ERROR in the execution. UNIX Please consult log l_ae.log. Press any key to continue . . . __Report End time is 05/06/2023:12:57:07.76 ... View more