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
Comments: To: "DUELL, BOB" <bd9439@att.com>
In-Reply-To:  <AC5F423B9AB19C43BE62C86BAF8113CC0E9ABB3C@WABOTH9MSGUSR8C.ITServices.sbc.com>
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
                                rename=(old1=new1))
             out=mypc.dsn2;
by vars;
run;

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.

thanks

On Fri, May 11, 2012 at 3:00 PM, DUELL, BOB <bd9439@att.com> 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,
>
> Bob
>
>
> -----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
> 9.1.3.
>
>
>
> 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
>                                 rename=(old1=new1))
>              out=lib.dsn2;
> by vars;
> run;
>
> any idea how I get rid of this warning?  The proc is working just as I
> expect, but the warning is annoying.
>
> TIA
>
> --
> Andrea W-Z
>



--
Andrea W-Z