Date: Fri, 16 Jul 2010 20:49:34 -0500
Reply-To: Craig Johnson <cjohns38@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Craig Johnson <cjohns38@GMAIL.COM>
Subject: Re: Character Date Conversion in PROC SQL
Content-Type: text/plain; charset=ISO-8859-1
My newness is showing! I'm connecting through a libname using an OLEDB
On Fri, Jul 16, 2010 at 5:00 PM, Joe Matise <firstname.lastname@example.org> wrote:
> Bit more detail - are you running just PROC SQL not connecting to anything
> (using LIBNAME access, basically), or is this passthrough to a server (using
> CONNECT TO)?
> If it's just PROC SQL not connected to anything, then INPUT will work
> fine. But if it's passthrough, you either need to do it in the first part
> of the passthrough:
> proc sql; connect to ... ;
> create table A as select a,b,c,input(d,'mm/dd/yyyy') as d from connection
> to ... ( select * from whatever);
> or you need to use your local database's terminology inside the connection
> to ... statement (cast, to_num, etc.).
> On Fri, Jul 16, 2010 at 4:54 PM, Craig Johnson <email@example.com> wrote:
>> I need to convert some dates stored in a database (10-10-2010 and
>> 10/10/2010) from character fields to numeric fields. What's the best way
>> go about this in PROC SQL?