Date:         Wed, 20 Jul 2011 16:18:32 -0500
Reply-To:     "Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: Comparison between datastep and proc SQL
Comments: To: SAS_learner <proccontents@gmail.com>
In-Reply-To:  <CAPo+ggvGp4x3SKwVNdCL7=Ubm5u2ck59-HDjX=_jy1YyQVNzTA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

I'm not sure what you mean by SQL LIST vs DATA STEP but I doubt that
there is a significant performance difference when compared time it
takes to run the MACRO 56 times.

On Wed, Jul 20, 2011 at 3:35 PM, SAS_learner <proccontents@gmail.com> wrote:
> 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
>