Date:         Tue, 20 Nov 2007 17:40:24 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: SQL Create table vs SET DATAFILE

On Tue, 20 Nov 2007 12:21:40 -0600, data _null_, <datanull@GMAIL.COM> wrote:

>Don't speculate test.
>
>On Nov 20, 2007 11:56 AM, JumboShrimps <google@pflaumnet.com> wrote:
>> Is there a difference?
>>
>> I mean using
>> PROC SQL;
>>   CREATE TABLE BASE AS
>> SELECT ID, TYPE, SOURCE
>> FROM  TEMP;
>>
>> **** OR ****
>>
>> DATA BASE;
>> SET TEMP;
>> RUN;
>>
>> Is there any substantial difference in terrms of memory allocation
>> (or anything else)
>> on an MVS system?
>>

The more exact equivalent SQL would be

   CREATE TABLE BASE AS SELECT * FROM TEMP;

I would expect the performance and resource requirements to be about the
same (SQL vs. DATA step), but D.N.'s advice to test is sound.