topic Re: How do I read multiple raw data files with different structure in one data step in SAS Procedures

How do I read multiple raw data files with different structure in one data step

Aj — Mon, 08 Feb 2016 15:46:07 GMT

1, I have multiple unstructured log files with different formats/Type of file i.e, : .log, .GTI, .txt files

2. I want to read them all into a single data step eg: file1.log, file2.GT1, file3.txt into a single data set.

3. I tried to import them using "infile 'C:filepath\*.log" but I will be missing the files from other formats. Is there a way to upload all of them at once?

Re: How do I read multiple raw data files with different structure in one data step

ballardw — Mon, 08 Feb 2016 16:15:17 GMT

If you want to ALL files in the directory then 'C:\path\*.*' if just the explicit extenstions then place the diffent file name bits within parentheses and use quotes such as

infile ('C:\path\*.log' 'C:\path\*.gti' 'c:\path\*.txt')

When getting something a bit off like this I tend to use a FILENAME statement to create a reference to my input files as then any of the actua INFILE options are easier to find.

Re: How do I read multiple raw data files with different structure in one data step

FreelanceReinh — Mon, 08 Feb 2016 22:49:22 GMT

I think, the INFILE statement (unlike the FILENAME statement) requires additional quotes around the parenthesized list:

infile "('C:\path\*.log' 'C:\path\*.gti' 'c:\path\*.txt')";

Re: How do I read multiple raw data files with different structure in one data step

Aj — Tue, 09 Feb 2016 14:10:19 GMT

Thanks ballard. I used the filename to get the names of all the files I imported.

Re: How do I read multiple raw data files with different structure in one data step

Aj — Tue, 09 Feb 2016 14:10:57 GMT

This worked for me too. Thank you very much