Date: Wed, 20 Jan 2010 08:40:13 -0800
Reply-To: Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Tom Abernathy <tom.abernathy@GMAIL.COM>
Organization: http://groups.google.com
Subject: Re: Internet log files
Content-Type: text/plain; charset=ISO-8859-1
Unless you want to restrict to a subset of the files can't you just
use a wildcard in your INFILE statement?
data logs;
infile 'dcs*.log';
input .... ;
run;
On Jan 20, 7:03 am, fabergoogle <fabrizio_marr...@bradycorp.com>
wrote:
> On Jan 20, 11:55 am, fabergoogle <fabrizio_marr...@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
> > ..............
> > ..............
>
> I also need to create a unique table appending all the imported files.
> Thanks.- Hide quoted text -
>
> - Show quoted text -
|