Date: Fri, 13 Oct 2000 09:21:21 +1100
Reply-To: "Crane, Philip" <Philip.Crane@TEAM.TELSTRA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Crane, Philip" <Philip.Crane@TEAM.TELSTRA.COM>
Subject: Re: Oracle dates
Content-Type: text/plain
Bernard
You could try defining an Oracle view of the table. The view would select
all columns from the table but convert the dates using the to_char function.
SAS code should then reference the view instead of the table.
Philip
Philip Crane
TBS Information Access
03 9634 2346
> -----Original Message-----
> From: Bernard Tremblay [SMTP:imaginasys@HOTMAIL.COM]
> Sent: Friday, 13 October 2000 6:09 am
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Oracle dates
>
> Hello SAS-L'ers,
>
> I would like to know how to handle date from Oracle with SAS.
>
> We have a DBLOAD that load an Oracle table and then we process it with
> SAS. Oracle dates ended like DATETIME16. instead of DATE9. The SAS code
> is
> used by others too and SAS dates are expected. Is there an easy way to
> handle this without changing the SAS code ?
>
>
> Regards,
> Bernard Tremblay
>
> \\\|///
> \\ - - //
> ( @ @ )
> +-----oOOo-(_)-oOOo--+-----------------------------------+
> | Bernard Tremblay | |
> | CSST | Tel: (418) 528-9313 |
> | | Fax: (418) 528-1493 |
> | | Int: Bernard.Tremblay@csst.qc.ca |
> +----------------------------+---------------------------+
> | Imaginasys enr | Res: (418) 658-1411 |
> | | Int: bertrem@videotron.ca |
> | | Hot: imaginasys@hotmail.com |
> +--------------Oooo--+-----------------------------------+
> oooO ( )
> ( ) ) /
> \ ( (_/
> \_)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
| 
