You have not shown that you actually generating datetime values at all.
Stop dropping and renaming and show.
Wrong is not any value as to what is the expected result.
I did an example above that 1) successfully creates datetime values and shows one possible result for LOS that you have never stated whether my result was "wrong" or why it did not meet expectations. We cannot help you if you will not actually answer questions.
You have not shared you actually starting data. There multiple reasons that your initial attempt to create a datetime value may fail. Pictures and values copied from Excel have no real value in testing SAS Code. You have character values. You are reading them with an informat that does have to guess as to the content. IF the values actually have leading spaces then the length you attempted to use would fail.
You have Code that starts this way:
data new_count;
set new_count;
That means you completely replaced the data set. It also means that you have very likely corrupted your initial values of the character version as you renamed and dropped stuff. So you have to go back to the step where you read the data into SAS.
Until you have much more experience in SAS any attempt at recoding existing variables into a same named variable should never use the same data set name on the Data and Set statements because all sorts of minor logic errors will corrupt your data. And rerunning the same code means the corruption is likely to get worse. Send the output to a new data set so you can compare the start and end results.
If you will not answer this question: What is the desired value for LOS when starting with HOSP_ADMSN_TIME 2022-05-12 11:35:00 and HOSP_DISCH_TIME of 2022-05-21 15:46:00, and what UNITS (days, hours, minutes, seconds, fortnights, weeks, months) are the answer then I will have to say that you really don't want the answer.
Also run this code:
Data example;
x1= "2022-05-12 11:35:00";
d1 = input(x1, anydtdtm15.);
d2 = input(x1, anydtdtm16.);
d3 = input(x1, anydtdtm17.);
d4 = input(x1, anydtdtm18.);
d5 = input(x1, anydtdtm19.);
format d: datetime20.;
run;
Note that the result for using a width of 17 results in missing datetime values because your data does not show 17 characters.
This value
2022-05-12 11:35:00
count them, has 19 characters. 17 is the : between the minutes and seconds and is an incomplete time so the input with the Anydtdtm17 informat returns missing values. So of course any manipulation returns a "wrong" result.
At this point 1) rerun what ever you did to bring the data into SAS. If you are getting a "17" character field that show use the actual SAS values. Not a picture from Excel. The SAS values. If there is supposed to be a minutes component that is not appearing then you need to fix how you read the data. Hint: very likely Proc Import is not your friend if this what you got in the past. Save the file to CSV if it is starting in EXCEL and read that file. Then show us the results.
