Date:         Mon, 1 Jun 1998 17:38:21 +0000
Reply-To:     kmself@ix.netcom.com
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Karsten M. Self" <kmself@IX.NETCOM.COM>
Organization: Self Analysis
Subject:      Re: SAS handling large files
Content-Type: text/plain; charset=us-ascii

Douglas Dame wrote:
>
> Chad Webb wrote:
>
> >
> > I am using an Informix database at the moment. We are looking at
> > migrating the Informix database into a SAS dataset. There are
> > approximately 7 million records and 800 variables to this database.
> >
> > Is there anyone who handles large data bases like this? Can you give me
> > some advice in what to look for when converting over? The way I initially
> > thought about doing this, was to divide the database into several files.
> > >From here, I would create a SAS dataset from one of these files, and
> > append all the rest. Does anyone see any problems to this method?
> >
> > I would like as much input as I can, before implementing this.
> >
>
> Working from this fairly generic description, can't give you much more than
> fairly generic advice back, but ...
 
 
I wrote a SUGI paper on large file processing in Unix environments.
It's available (pdf format) at:
 
http://www.netcom.com/~kmself/SAS/unix_lfs.pdf
 
....and discusses several ways of working with large files.
 
--
Karsten M. Self (kmself@ix.netcom.com)
 
    What part of "gestalt" don't you understand?
    Welchen Teil von "gestalt" verstehen Sie nicht?
 
        web:       http://www.netcom.com/~kmself
        SAS/Linux:
http://www.netcom.com/~kmself/SAS/SAS4Linux.html
 
 10:33am  up 32 days, 12:39, 13 users,  load average: 1.22, 1.23, 1.26