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

Santt0sh — Mon, 10 Dec 2018 22:00:13 GMT

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...

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

Santt0sh — Mon, 10 Dec 2018 22:02:06 GMT

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 */

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

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

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