Date: Mon, 13 Nov 2006 11:08:17 -0800
Reply-To: Sekhar <ckalisetty@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sekhar <ckalisetty@GMAIL.COM>
Subject: Sorting a huge huge dataset
Content-Type: text/plain; charset="iso-8859-1"
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.