Date:         Thu, 6 Jul 2006 03:43:40 -0700
Reply-To:     Andreww <andrew.whittam@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andreww <andrew.whittam@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: mergeing datasets WITHOUT prior sorting
Comments: To: sas-l@uga.edu
In-Reply-To:  <1152120927.164811.227270@m73g2000cwd.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi - Opinion here was very similar.

Thanks

Andrew

shiling99@yahoo.com wrote:
> 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;
>
>
> HTH
>
> Andreww wrote:
> > 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.
> >
> > Thanks
> >
> > Andrew