topic Re: How to read data into SAS from some files with different names but with the similar inner structure automatically? in SAS Data Science

How to read data into SAS from some files with different names but with the similar inner structure automatically?

stan — Sun, 27 May 2012 16:09:13 GMT

For example, I have the files (within the same directory) named with

human_CDx+CDx+xxh_1way_RM_ANOVA

common fragment in its names.

The inner structure of the files is as follows:

LINE with text

LINES with DATA

LINE with text

Re: How to read data into SAS from some files with different names but with the similar inner structure automatically?

PGStats — Sun, 27 May 2012 16:41:07 GMT

INFILE supports simple wildcard characters (both in Windows and Unix) for reading multiple files. Use filename= option to know where each observation comes from, as in

infile ('c:\myfiles\*.*','c:\myotherfiles\abc.dat') filename=whatFile;

Re: How to read data into SAS from some files with different names but with the similar inner structure automatically?

stan — Sun, 27 May 2012 17:15:36 GMT

It works! But my intention is to make SAS compute different data sets

stored in '.txt' files located in a directory consequently. One by one.

There is an article at UCLA website:

SAS FAQ: How do I read multiple raw data files with the same structure in one data step?

But I get a big table with directories and data themselves instead of my SAS script

consecutive execusions with different data sets.

How to implement this?

Thanks for any response.