- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 06-22-2021 05:18 AM
(1155 views)
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.