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
Here is one method: http://support.sas.com/kb/24/707.html
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;
Calling all data scientists and open-source enthusiasts! Want to solve real problems that impact your company or the world? Register to hack by August 31st!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.