<wingsze_tsui@HOTMAIL.COM> wrote in message news:200405130130.i4D1UgG01377@listserv.cc.uga.edu... > Hi, > > I'm trying to update a wide table (with 1970 columns and 1,500,000 rows and > a size of ~ 24G) with a transaction dataset (with 300 columns and 1,300,000 > rows and a size of ~7G). The master dataset already have index and the > transaction dataset is sorted. > > I've tried to use data step modify and it took ~2.5 hrs on a Windows2000 > Server with 4G RAM. Is there anyway I can improve the performance? > > HELP! > > Thanks a lot in advance! > > Wing.

Wing:

What is the nature of the columns ? All numeric ? wide characters ? Perhaps you could post the first portion of the output of PROC CONTENTS.

What is the nature of the update ? Is it a data step with an UPDATE statement, a MODIFY statement or a SET statement? Are you trying to Proc APPEND ?

You might also unsubscribing and resubscribing with a 'fixed' name. Your subscription name is "SUBSCRIBE SAS-L WingSze" which can causes newsgroup replies to your questions to be rejected by the listserv.

-- Richard A. DeVenezia http://www.devenezia.com/downloads/sas/samples