LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 1997, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 28 May 1997 22:20:59 -0400
Reply-To:     Eric Weiss <eweiss@WINCHENDON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Eric Weiss <eweiss@WINCHENDON.COM>
Organization: The Winchendon Group, Inc.
Subject:      Re: SQL: When shouldn't you use it?

I like SQL when the retieval involves only minimal calculations. I benchmarked PROC SQL on a Sun IPX and found that it slowed down greately when I did multiplication or division. Even addition and subtraction make a noticeable difference in speed. It seems to be most useful when there are several merges/joins that do not require a lot of parentheses to make work.

Eric


Back to: Top of message | Previous page | Main SAS-L page