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

[fieldsa83]

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]

Hi,

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

Take a look at examples 10 & 13

[ballardw · Accepted solution]

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.