Date: Thu, 21 Jul 2011 16:14:42 +0000
Reply-To: "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Subject: Re: Comparison between datastep and proc SQL
Content-Type: text/plain; charset="us-ascii"
There are substantial differences in time used
SQL dictionary tables
and SAShelp views
especially if you are writing repetitive calls to dictionary tables
which are updated in each step
be aware of the (increasing) time used.
Ron Fehd list processing maven
> -----Original Message-----
> From: email@example.com [mailto:firstname.lastname@example.org]
> On Behalf Of SAS_learner
> Sent: Wednesday, July 20, 2011 4:35 PM
> To: SAS(r) Discussion
> Subject: Comparison between datastep and proc SQL
> Hello all,
> Recently I used proc sql lists to run my macros ( 56 times ) and one of the
> senior programmers claimed that by using data step process It would be
> much faster than by running Proc SQL.. Is there really difference between
> execution speeds of Proc SQL and data step??? If I need to show him that
> both are exactly same how can I prove that both the steps execute in same
> time ??
> I see lot of people who feel Proc sql is little slower than datastep ? How far it
> is true ??