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
In-Reply-To:  <CAPo+ggvGp4x3SKwVNdCL7=Ubm5u2ck59-HDjX=_jy1YyQVNzTA@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

There are substantial differences in time used
between
SQL dictionary tables
and SAShelp views

http://www.sascommunity.org/wiki/List_Processing_Development#Speed_Considerations

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: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
> 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 ??
>
>
> thanks
> sl