Hi All,

I have serial measurements of air pollution data that are collected from several places at various points in time. The data are comma delimited and logged every minute (sample shown below). Apart from the header which differs, all collection are of similar format having 3 variables - Date, Time and Aerosol. Each file is named with place ID and date of collection. Two such successive files for ID1 are named Man01_030408.txt and Man01_100608.txt as an example. I have hundreds of such files and need to automate the import of these files into SAS and save the file with similar name to the text file. How can I employ this situation?

Thanks for your input.

Sample data follows.

TrakPro Version 4.00 ASCII Data File Model:,SidePak Aerosol Monitor Model Number:,AM510 Serial Number:,10707008 Test ID:,002 Test Abbreviation:, Start Date:,04/03/2008 Start Time:,12:44:15 Duration (dd:hh:mm:ss):,0:08:37:00 Time constant (seconds):,0 Log Interval (mm:ss):,01:00 Number of points:,517 Notes:,

Date,Time,Aerosol dd/MM/yyyy,hh:mm:ss,mg/m^3 04/03/2008,12:45:15,0.004 04/03/2008,12:46:15,0.006 04/03/2008,12:47:15,0.003 04/03/2008,12:48:15,0.003 04/03/2008,12:49:15,0.002 04/03/2008,12:50:15,0.004 04/03/2008,12:51:15,0.010 04/03/2008,12:52:15,0.005 04/03/2008,12:53:15,0.016 04/03/2008,12:54:15,0.010