Date:         Thu, 10 May 2012 13:15:39 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: How to cancel SAS session which involves ODBC connection w DW
              through PROC SQL?
Comments: To: Irin later <irinfigvam@yahoo.com>
In-Reply-To:  <1336672864.42709.YahooMailNeo@web39402.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1

I usually ask my DBA to do so :)  And I very regularly accidentally do
cartesians...

-Joe

On Thu, May 10, 2012 at 1:01 PM, Irin later <irinfigvam@yahoo.com> wrote:

> I mistakenly run PROC SQL and it will take forever (cartesian).
> Unfortunately it involved ODBC connection.
>
>
> libname mylib odbc
> complete="driver={sql server};
> server=Reportp01; Database=DW,"
> schema=DBO;
>
> Try as I might I was unable to cancel it?
>
> How can I do it?
>