Import all txt files in to a single sas dataset

[ani]

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

[art297]

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

[Tom]

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;