Re: Internet log files #2

  • Follow


You don't want a macro!

You need to look at the INFILE statement options FILENAME FILEVAR EOV
EOF END.  You can read all the files as one using a wild card in a
FILENAME statement or you can make a list(data set) with the names and
process each one individually using FILEVAR.  There are lots of
examples of both in the archives.

Since the data start on the 6th record of each file using FILEVAR to
open each file will probably be best so you can also use INFILE option
FIRSTOBS=6.

On 1/20/10, fabergoogle <fabrizio_marrama@bradycorp.com> wrote:
> Hi,
>
> I need to import 9,322 internet log files which have 9,322 different
> names. I'd rather to name manually the columns (because the first
> field name would start in the 2nd data column). The data start at the
> 6th row. The delimiter is the "space".
>
> Could you please advice on a macro to do this job please?
>
> Example:
> dcs0euxln09tjxucaxis09t1m_4v6d-dcs-2009-01-01-00-00135.log
> dcs0euxln09tjxucaxis09t1m_4v6d-dcs-2009-01-01-01-00234.log
> dcs0euxln09tjxucaxis09t1m_4v6d-dcs-2009-01-01-02-00427.log
> dcs0euxln09tjxucaxis09t1m_4v6d-dcs-2009-01-01-03-02832.log
> dcs0euxln09tjxucaxis09t1m_4v6d-dcs-2009-01-01-04-00215.log
> ..............
> ..............
>
0
Reply iebupdte (1746) 1/20/2010 4:03:52 PM


0 Replies
38 Views

(page loaded in 0.027 seconds)


Reply: