LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 19 Mar 2009 10:13:29 -0700
Reply-To:     Olaanaa <walaba@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Olaanaa <walaba@GOOGLEMAIL.COM>
Organization: http://groups.google.com
Subject:      Import many text files
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

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


Back to: Top of message | Previous page | Main SAS-L page