Date:         Wed, 26 Apr 2000 00:03:34 +0100
Reply-To:     Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Organization: Crawford Software Consultancy Limited
Subject:      Re: SQL and variable formats

Philp, Stephen R. <Stephen.Philp@CSHS.ORG> writes
>I have some pass-through SQL going against some Oracle tables and am having
>a hard time trying to figure out how to format a date.  The variable in my
>new table is a sas date with a datetime format (01DEC1998:00:00:00), but
>when I try to format it to mmddyy10. it has invalid data.
>Could anyone offer some help?
>Thanks,
>Stephen Philp

From Oracle you get a datetime value... with 0 for the time part
Create your own version of the datetime format (nested) for example:-

proc format;
 value mydatet other=[datetime19.];

then use the format  like
  format oradatet mydatet10.;

--
Peter Crawford