Sekhar,

There are several ways of doing this without SORTING but it depends on the
type of account number. Can you put sample of both files on SAS-L and you
may get better solution.

Muthia Kachirayan

On 11/13/06, Sekhar <ckalisetty@gmail.com> wrote:
>
> Hi
> I am trying to merge two datasets one having 1.7 billion records and
> the other one having 35 million records. The first datset has accoutn
> number and the second datset has opeinign date. The merge is on account
> number. So far so good.But sorting the first file on account number is
> taking almost 8 hours.Any other alternatives for doing this or any
> other methods for getting the opening date in to the first file. Tag
> sort, Proc SQl, Indexing?? Any suggestions? Should cahnge the system
> options like memsize,sortsize etc.. I am more concerned about cutting
> down the time than space issues.
>

Muthia
I will post some sample obs. tomorrow after getting back to work.
Muthia Kachirayan wrote:
> Sekhar,
>
> There are several ways of doing this without SORTING but it depends on the
> type of account number. Can you put sample of both files on SAS-L and you
> may get better solution.
>
> Muthia Kachirayan
>
> On 11/13/06, Sekhar <ckalisetty@gmail.com> wrote:
> >
> > Hi
> > I am trying to merge two datasets one having 1.7 billion records and
> > the other one having 35 million records. The first datset has accoutn
> > number and the second datset has opeinign date. The merge is on account
> > number. So far so good.But sorting the first file on account number is
> > taking almost 8 hours.Any other alternatives for doing this or any
> > other methods for getting the opening date in to the first file. Tag
> > sort, Proc SQl, Indexing?? Any suggestions? Should cahnge the system
> > options like memsize,sortsize etc.. I am more concerned about cutting
> > down the time than space issues.
> >