Date: Thu, 13 May 2004 10:55:50 -0400
Reply-To: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject: Re: Updating a wide dataset
<wingsze_tsui@HOTMAIL.COM> wrote in message
> I'm trying to update a wide table (with 1970 columns and 1,500,000 rows
> a size of ~ 24G) with a transaction dataset (with 300 columns and
> 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?
> Thanks a lot in advance!
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
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