09-20-2011 08:52 AM
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
09-20-2011 09:42 AM
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 ;
input column1 ;
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');