Kristine,

66 data _null_; 67 do a = '7/26/200008:08AM','12/3/199908:08PM'; 68 dtm = input(substr(a,1,length(a)-7),mmddyy10.)*86400 69 + input(substr(a,length(a)-6),time.); 70 put dtm= datetime.; 71 end; 72 run;

DTM=26JUL00:08:08:00 DTM=03DEC99:20:08:00

Kind regards, ======================== Paul M. Dorfman Jacksonville, Fl ========================

>From: "Dougherty, Kristine" <dougherty.kristine@MAIL.DC.STATE.FL.US> >Reply-To: "Dougherty, Kristine" <dougherty.kristine@MAIL.DC.STATE.FL.US> >To: SAS-L@LISTSERV.UGA.EDU >Subject: datetime formats >Date: Fri, 28 Jul 2000 13:05:36 -0400 > >I'm trying to save as delimited ascii some data from a Cognos Impromptu >query which accesses an Oracle database and then bring it into SAS. I've >tried everything to get Impromptu to write the datetime fields out in the >proper format for the SAS datetimew. format -- >ddmmmyy hh:mm. I'm not having any luck on that end. So, does anybody >know >how to get SAS to accept as a datetime value a field in the format >7/26/2000 >08:08AM? I need to preserve both the date and the time. > >Kris Dougherty >Research & Data Analysis >FL Dept. of Corrections >850-410-4487 >dougherty.kristine@mail.dc.state.fl.us

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com