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

[PatrykSAS]

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]

Use the DHMS function.

[NicoM]

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.