DATA Step, Macro, Functions and more

Import all txt files in to a single sas dataset

Reply
Occasional Contributor ani
Occasional Contributor
Posts: 10

Import all txt files in to a single sas dataset

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 Smiley Happy

PROC Star
Posts: 7,468

Import all txt files in to a single sas dataset

Super User
Super User
Posts: 7,039

Import all txt files in to a single sas dataset

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;

Ask a Question
Discussion stats
  • 2 replies
  • 152 views
  • 3 likes
  • 3 in conversation