topic e8601dt format returns 01/01/1960 in SAS Programming

e8601dt format returns 01/01/1960

mglogan — Fri, 04 Jan 2019 06:07:53 GMT

Hello,

Does anyone understand why my format is is returning a value of 01/01/1960? Thanks in advanced!

My code is below and my unformatted data is as follows:

- collection_date: date11. (i.e., 19-JUL-2017)

- pctim = character (i.e., 10:55, 10:10, 11:55 etc.)

if nmiss (collection_date)= 0
				then do ;
					pcdt = collection_date;
					pcdtc = put(collection_date + input(pctim, time5.),e8601dt.) ;
				end;

novinosrin — Fri, 04 Jan 2019 06:22:04 GMT

try using dhms to create a datetime value using date and time value

Assuming your date is a sas numeric date

datetime=put(dhms(collect_date,0,0,input(pcttm,time5.)),e8601dt.);

and then apply an appropriate format

mglogan — Fri, 04 Jan 2019 07:07:13 GMT

Thank you so much!