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
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 <firstname.lastname@example.org> 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 ??