Date: Mon, 13 Feb 2006 11:09:54 -0500
Reply-To: Laurel A Copeland <copelandl@UTHSCSA.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Laurel A Copeland <copelandl@UTHSCSA.EDU>
Subject: Re: Need good book on merging in SAS
Regarding Machelle's comment "I'm of the belief that anything Merge can
do, SQL can do better...", I would caution that, when you are paying for
the CPU time, this is not always true. The trade-offs between time and
space in certain environments can mean that a DATA step on indexed/sorted
(important qualification) datasets is much cheaper than equivalent PROC
SQL. In some jobs, this can translate into the "better" option. -Laurel
Copeland, Dept Veterans Affairs
|