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 <email@example.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;
>> 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.