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

[AK100]

This is what I have:

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

[PaigeMiller]

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.

[AK100]

Done that but got empty values back?

[PaigeMiller]

---

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

---

Did what? Show us your code

[PeterClemmensen]

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; 

[AK100]

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; 

[Kurt_Bremser]

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.

[PaigeMiller]

---

@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.