topic Import all txt files in to a single sas dataset in SAS Programming

Import all txt files in to a single sas dataset

ani — Tue, 20 Sep 2011 12:52:34 GMT

How to import multiple files in to a sas dataset located in a particular library. For example, suppose there are 5 txt files present in your local system and you need those 5 txt will appnd in a single sas dataset . Output dataset will have a single column.

Please help to write this Proc import.

Thanks in advance

Import all txt files in to a single sas dataset

art297 — Tue, 20 Sep 2011 13:04:41 GMT

Here is one method: http://support.sas.com/kb/24/707.html

Import all txt files in to a single sas dataset

Tom — Tue, 20 Sep 2011 13:42:37 GMT

Depends on what you mean by "import". If you just have text files then I would just "input" them and would not bother with using any import functionality.

1) If the file names follow a simple pattern then just us a wildcard in the filename specification.

data all ;

infile '*.txt';

input column1 ;

run;

2) If you have a static list of filenames then build a FILENAME statement.

filename myfiles ('one.txt','two.txt,'three.txt','four.txt','five.txt');

data all;

infile myfiles;

input column1;

run;