Date:         Sun, 30 Sep 2007 00:39:13 -0700
Reply-To:     Hari <excel_hari@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Hari <excel_hari@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: OUTER JOIN and order of WHERE Clause processing
Comments: To: sas-l@uga.edu
In-Reply-To:  <1191124695.404415.118210@50g2000hsm.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

On Sep 30, 8:58 am, Patrick <patrick.mat...@gmx.ch> wrote:
> Hi Hari
> I'm also working through this training. Are you happy with the
> response times?
>
> Quite interesting your findings. I think that the note for the outer
> join is wrong.
>
> I found quite an interesting SUGI paper:http://www2.sas.com/proceedings/sugi30/101-30.pdf
>
> Using the SQL option _method as described in this paper, your code
> generates the following log messages:
>
> First SQL:
>       sqxslct
>           sqxfil
>               sqxjm
>                   sqxsort
>                       sqxsrc( SASUSER.FLIGHTSCHEDULE(alias = F) )
>                   sqxsort
>                       sqxsrc( SASUSER.PAYROLLCHANGES(alias = P) )
>
> Second SQL:
>       sqxslct
>           sqxjm
>               sqxsort
>                   sqxsrc( SASUSER.FLIGHTSCHEDULE(alias = F) )
>               sqxsort
>                   sqxsrc( SASUSER.PAYROLLCHANGES(alias = P) )
>
> This two SQL differ only in one step which comes in the very end:
> sqxfil     ...and sqxfil means "filter rows"
>
> Conclussion: The left outer join is processed first, the where clause
> subsets the result of the join.
>
> Very curious what other more experienced SAS/SQLers will answer.
>
> Patrick

Patrick,

Thanks for the helpful paper link for the option_method (hadnt used
this before). Im relieved to note that Im not the only one who found
the note to be in disagreement with actual output. Yes, I would also
like some expert thoughts on the same.

Ah!..Response times --> Im accessing from India and the normal load
times for any web-page is usually slower than what is in US. But yes
the SAS online training is just too much. I click on a page and on
average wait for 15/20 seconds for a text page to load? (what about
you?) Im on a broadband connection (ISP's claim is 512 Kbps) acessing
from home (only slightly better when I access from office)

I wonder whether this is partly happening because of the RESUME
feature in their training home-page. I mean each time we click on a
new-page then SAS stores the page being accessed by me in its internal
database, so that if I shut down in middle, then next time I can
continue from last page accessed

One way to speed up access which I found helpful is to manually type
in the new page address and press enter. For ex if the last few
strings in the web-page is "/m73_5.htm" then for next page I just
change it to "/m73_6.htm". It faster as compared to using the arrow
icons "Display the next page" in the bottom.

Hope it helps.

All the best for your exam!

hp