topic Re: Converting date9 to ddmmyyyy:hh:mm:ss in SAS Programming

Converting date9 to ddmmyyyy:hh:mm:ss

Sathish_jammy — Wed, 26 Sep 2018 10:21:06 GMT

Hi community

I import the dataset from excel which contains date values in the format of date9.

Once i tried to convert it to DATETIME format it look like

data a1;
set b1;
rec_date = datepart(Record_date);
format rec_date datetime.;
run;

SAS Output

Obs Patient_ID Record_Date rec_date12

186089	08DEC2017			01JAN60:00:00:00
111247	31JUL2015			01JAN60:00:00:00

Please help me to solve it.

Thanks in advance!

Re: Converting date9 to ddmmyyyy:hh:mm:ss

s_lassen — Wed, 26 Sep 2018 10:46:19 GMT

You have to do it the opposite way. The DATEPART function converts datetimes to dates, what you want is the opposite, try with DHMS:

data a1;
  set b1;
  rec_date = dhms(Record_date,0,0,0);
  format rec_date datetime.;
run;

Re: Converting date9 to ddmmyyyy:hh:mm:ss

Kurt_Bremser — Wed, 26 Sep 2018 10:54:27 GMT

Datetimes (and times) are counts of seconds, dates are counts of days.

So, roughly

datetime = date * 86400

(86400 seconds per day)

The datepart function basically does

floor(datetime / 86400)

So when you use it on a date (which today means 21453), you get zero, and zero as a datetime is midnight on 1960-01-01.

Re: Converting date9 to ddmmyyyy:hh:mm:ss

data_null__ — Wed, 26 Sep 2018 12:30:04 GMT

It is possible that your date value from excel has the time part as a decimal.

125  data _null_;
126     date = today() + .32;
127     put 'NOTE: ' date=date9. date=;
128     datetime = dhms(date,0,0,0);
129     put 'NOTE: ' datetime=datetime19.;
130     run;

NOTE: date=26SEP2018 date=21453.32
NOTE: datetime=26SEP2018:07:40:48