Need to read .log files from two different locations and create a single SAS dataset

[Santt0sh]

Hi All,

I need to read .log files from two different locations, or folders and create a single data to process the events listed in the .log file to a SAS data set

i am currently using the below code and i am not sure how to loop this and read the files into a SAS data set.

%let pth = /workspace/xxxx/xxxx/sasdta/ABC/logs/t1; /*one of the locations where the files are stored */

filename flx pipe "ls &path";

data x1;

length name $255.;

infile pth;

input name $;

lst_wrd = input(scan(name,-1,'.'),yymmdd10.);

fpth = "&pth./"||name;

if lst_wrd = '.' or lst_wrd ge "stdte."d then

output;

run;

/*to get the relevant files*/

data _null_;

 set x1;

call execute ("filename lrecds pipe 'more"||pth||" | grep com.sas.solutions.casemgmnt.util.AppSessionContext';

data x2;

length fnme $1000;

infile lrecds lrecl = 1000 dlm = '7F'x missover truncover dsd;

input fnme $;

if find (fnme,'INFO') then output;

run;

proc append base = x3 data = x2;

run;");

Run;

Please suggest me on this .

Thanks...

[Santt0sh]

Sorry i missed to mention, i also need to read files from another location, 

Location 2 :

%let pth1 = /workspace/xxxx/xxxx/sasdta/ABC/logs/t2; /*one of the locations where the files are stored */