LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


Back to: Top of message | Previous page | Main SAS-L page