Date: Fri, 11 May 2012 15:15:15 -0400
Reply-To: Andrea Zimmerman <sassywench74va@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Andrea Zimmerman <sassywench74va@GMAIL.COM>
Subject: Re: I'm getting a new warning now that I've upgraded to 9.3
Content-Type: text/plain; charset=ISO-8859-1
yes, should have been a little more careful with my dummy example, the
input is an Oracle database.
So a more accurate example would be:
proc sort data=or_table.dsn(keep=var1 var2
I'll try moving the rename to the out dataset and see if that eliminates
the warning. I do want to avoid having an extra datastep just to do the
rename if I can do it while I sort.
On Fri, May 11, 2012 at 3:00 PM, DUELL, BOB <firstname.lastname@example.org> wrote:
> I suspect this is just an example and not really your actual code, because
> as written, it does not make sense to me.
> At any rate, I'm guessing that the data source associated with your libref
> LIB is pointing to a non-SAS database (perhaps Oracle or something). That
> would explain the message about SQL and why that option is not supported.
> Then again, you show creating a new "dataset" in that same library so it's
> not clear to me.
> At any rate, to avoid the messages, try moving those options to the "out"
> dataset reference where the new table is being created. That might work.
> Good luck,
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@listserv.uga.edu] On Behalf Of
> Andrea Zimmerman
> Sent: Friday, May 11, 2012 10:59 AM
> To: SAS-L@listserv.uga.edu
> Subject: I'm getting a new warning now that I've upgraded to 9.3
> I'm getting the following warning in code that produced no warning in
> WARNING: SQL generation was not performed because the RENAME statement,
> data set option, or
> libname option is not supported.
> Wierd thing is I'm not doing SQL, this is following:
> proc sort data=lib.dsn(keep=var1 var2
> by vars;
> any idea how I get rid of this warning? The proc is working just as I
> expect, but the warning is annoying.
> Andrea W-Z