topic How can I read multiple files placed in a location to one file in SAS Programming

How can I read multiple files placed in a location to one file

Saket_90 — Sat, 23 Apr 2016 12:52:35 GMT

Hi,

I am trying to load the data from multiple text files palced in a folder having the same structure to one file. All the text files are having the same headers.

Sample data in one of the file:

Product Customer Qtr 1 Qtr 2 Qtr 3 Qtr 4
Alice_Mutton ANTON 28080 70200 110400 55125
Aniseed_Syrup BERGS 31200 78000 60000 14700
Boston_Crab BOLID 28080 6000 77280 117000
Escargots_Bourgogne BOTTM 117000 20000 16560 122360
Filo_Mix ERNSH 112320 18000 92000 260715
Geitost GODOS 6240 28080 24840 41952

Also the names of the file are cust101, cust102, cust103.........Cust200...

Can anyone please suggest an efficient way to read the data from all these text file in to a single file.

Regards,

Saket

Re: How can I read multiple files placed in a location to one file

Cynthia_sas — Sat, 23 Apr 2016 15:02:31 GMT

Hi:
This Tech Support note describes one method:
https://support.sas.com/techsup/technote/ts581.pdf

cynthia

Re: How can I read multiple files placed in a location to one file

Pamela_JSRCC — Sat, 23 Apr 2016 15:39:28 GMT

You can read multiple files using wildcrds. The code below is not tested but should help get you started.

%let data_filepath = c:\...\cust*; * modify path as appropriate for your system;

data temp;
infile firstobs=2 "&data_filepath";
input product $ customer $ qtr1-qtr4;
run;

Re: How can I read multiple files placed in a location to one file

Reeza — Sat, 23 Apr 2016 15:41:40 GMT

Here's my recommended solution:

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627

1. You need your input/informat/format statement for reading a single file.

2. In the code in link above, change the path, and use a wildcard to reference the data.

3. Make sure to use the EOV= variable to avoid reading the header in each file.