Date: Wed, 5 Jul 2006 10:35:27 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: mergeing datasets WITHOUT prior sorting
Content-Type: text/plain; charset="iso-8859-1"
I think it is legitimate. Put the following option before merge
statement, you will see how sas merge works when connecting to a
database defined through a libname engine.
options sastrace=',,,d' sastraceloc=SASLOG;
> Hi - I am working on a client site with SAS 9 which uses/allows to
> connect to Oracle tables.
> I've been given some old code to convert and notice that there are a
> load of merges in datasets with the correct "by" syntax... but the
> input Oracle tables aren't sorted using proc sort in the code.
> When I run the datasetep with merge it seems to work i.e. no error
> about by vars not sorted!
> I don't believe the tables are indexed on the by group var.
> Is this legitamate or have I just been lucky.