SAS 9.2 I have a date field appointment_date and it shows '10Jan2014'. It is a date field and not text field. And then I run this SAS code: data NCA_OAOS3x; set NCA_OAOS3 (where=(oaos_case_no='S140106-5')); appt_date_timex=dhms(appointment_date,12,0,0); format appt_date_timex datetime.; run; It returns 11JAN14:02:00:00 And if I run this SAS code: data NCA_OAOS3x; set NCA_OAOS3 (where=(oaos_case_no='S140106-5')); appt_date_timex=dhms(appointment_date,0,0,0); format appt_date_timex datetime.; run; It returns 10JAN14:14:00:00 Can anyone explain why the hour component is not returning as expected? There seems to be hour component in the date field. Date field is actually '10Jan14:14:00:00'
... View more