topic Reading in multiple text files (with different folders and file extensions) in SAS Programming

Reading in multiple text files (with different folders and file extensions)

fieldsa83 — Wed, 31 Oct 2018 15:48:20 GMT

I am trying to get several files that have the same layout in, but it will only keep data from the last file.

(note separate folders and file extensions)

Cannot figure it out!

data myfile;

infile "/microdata/file1.prn" lrecl=430 missover;

infile "/microdata/otherfolder/file2.txt" lrecl=430 missover;

infile "/microdata/anotherfolder/file3.txt" lrecl=430 missover;

@119 AGE 3. /* Age of respondent */

@122 SEX $1. /* Sex of respondent. */

run;

AMSAS — Wed, 31 Oct 2018 15:56:36 GMT

Hi,

Take a look at the MEMVAR & FILEVAR options for the infile statement

Take a look at examples 10 & 13

ballardw — Wed, 31 Oct 2018 16:08:09 GMT

Might also try

filename ToRead ("/microdata/file1.prn", "/microdata/otherfolder/file2.txt",  "/microdata/anotherfolder/file3.txt");

and use

INFILE ToRead lrecl=430 missover;

There may be issues caused by column headers in the data files if present.