Date:         Mon, 21 Aug 2006 14:54:58 -0400
Reply-To:     Doug Rohde <drohde01@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Doug Rohde <drohde01@COMCAST.NET>
Subject:      Re: URGENT: PROC SORT TO PROC SQL CONVERSION

Indeed.

I'm not sure what good instructors think they are doing by forcing this
sort of ridiculous contrived example.  If you want people to learn Proc
SQL, at least give a practical example.

Furthermore, if by some wierd circumstance my employer ever mandated that
I don't use proc sort in my SAS code, I would seek employment elsewhere
immediately.

Doug R

On Mon, 21 Aug 2006 16:59:01 +0000, toby dunn <tobydunn@HOTMAIL.COM> wrote:

>I am sorry but this looks like a howwork assignment to me, cant use proc
>sort, what do you think SQL is doing in the back ground.  If the data isnt
>sorted and SQL deems it neccessary to sort the data first it will do so,
you
>just wont be explicitly sorting the data.  So what does it matter if you
>first sort the data or you let proc SQL do the sorting for you.
>
>
>
>Toby Dunn
>
>Normal People Worry Me!!!!!
>
>I reject your reality and substitute my own!!!
>
>
>
>
>
>From: Abhijat <ursabhijat@GMAIL.COM>
>Reply-To: Abhijat <ursabhijat@GMAIL.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Re: URGENT: PROC SORT TO PROC SQL CONVERSION
>Date: Mon, 21 Aug 2006 09:51:38 -0700
>
>Hi Scott/Byron ,
>Thanks for your replies.
>
>Scott: Proc Sort is not disabled . I am not supposed to use proc sort
>in my code. In fact I am only supposed to use Proc Sql for coding. If I
>had to use Proc Sort, I wudn't be posting this query here :-) !
>
>Byron: I am going to use your idea and have a loook at the result. Many
>Thanks once again !
>
>Regards,
>Abhijat.
>
>