topic Re: Create timestamp yyyy-MM-dd HH:mm:ss in SAS Programming

Create timestamp yyyy-MM-dd HH:mm:ss

PatrykSAS — Tue, 22 Jun 2021 09:18:53 GMT

Hello,

I have variable with date and hour, what I'd like to do is to create a timestamp. For example:

DATE	HOUR
2021-06-22	13

I wish I could get 2021-06-22 13:00:00

How can I solve that?

Kurt_Bremser — Tue, 22 Jun 2021 09:39:12 GMT

Use the DHMS function.

NicoM — Tue, 22 Jun 2021 09:46:18 GMT

Indeed you can do this using the DHMS function. Assuming your variable DATE is a SAS date and HOUR is numeric you would get something like this.

data want; 
	date = '22jun2021'd; 
	hour = 13; 

	timestamp = dhms(date, hour, 0, 0);

	format date date9. timestamp datetime22.; 
run;

In case your DATE variable is character, you would need to do some pre-processing to get to the timestamp.