topic Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS? in SAS Enterprise Guide

How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

AK100 — Wed, 10 Feb 2021 12:48:35 GMT

This is what I have:

I want to concatenate them all to 1 DATETIME format. How can that be done in a fast way?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

PaigeMiller — Wed, 10 Feb 2021 12:52:06 GMT

You can use the MDY function to get a SAS date.

Then you can use the DHMS function to turn that date, plus hour minute second into a SAS datetime value.

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

PeterClemmensen — Wed, 10 Feb 2021 12:52:36 GMT

See if you can use this as a template

data have;
input Year Month Day Hour Minute Second;
datalines;
2020 9 7 0 0 0
;

data want;
   set have;
   date = mdy(Month, Day, Year);
   datetime = dhms(date, Hour, Minute, Second);
   format date ddmmyy10. datetime datetime20.;
run;

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

AK100 — Wed, 10 Feb 2021 13:05:17 GMT

Done that but got empty values back?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

PaigeMiller — Wed, 10 Feb 2021 13:07:35 GMT

@AK100 wrote:
Done that but got empty values back?

Did what? Show us your code

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

AK100 — Wed, 10 Feb 2021 13:17:51 GMT

Got This back, No DATALINES or INFILE statement.. Probably because I have this:

data work.merged_table;
input Year Month Day Hour Minute Second; 
;

data want;
   set work.merged_table;
   date = mdy(Month, Day, Year );
   datetime = dhms(date, Hour, Minute, Second);
   format date ddmmyy10. datetime datetime20.;
run;

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

Kurt_Bremser — Wed, 10 Feb 2021 13:22:26 GMT

ALWAYS

supply example data in a data step with datalines, if you expect quick responses with a working suggestion.

A picture cannot be tested against, and we have NO IDEA AT ALL how your data really looks like.

Since the suggested code does work, the issue has to be your data.

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

PaigeMiller — Wed, 10 Feb 2021 13:26:57 GMT

@AK100 wrote:

Got This back, No DATALINES or INFILE statement.. Probably because I have this:

If you program work.merged_table as you did, it will be an empty data set. So, this is most likely the first problem you have.