Difference between two different format dates.

[Reeza]

  Death_SAS_Date = input(put(DEATH_DT, 8. -l), YYMMDD10.) - Index;
  Death_days = Death_SAS_Date - Index;

You're subtracting the index twice. You can literally copy and paste my previous code to get this right.

---

@Sujithpeta wrote:

My bad @Kurt_Bremser, I corrected the code as @Reeza posted 

data M.Death;
set M.Death;
  Death_SAS_Date = input(put(DEATH_DT, 8. -l), YYMMDD10.) - Index;
  Death_days = Death_SAS_Date - Index;
run;

Death_SAS_Date still in the format of BEST12. and Death_days are also in the format of BEST12.

---

[Sujithpeta]

I corrected but it still gives the same output @Reeza

[Reeza]

When I did it with the correct formulas it worked perfectly.

When you say something isn’t working, show your code. I suspect you still have two indexes in your code. The original code, without the N in the format and with only one index is still correct. If that doesn’t work post your full code and log.

[PaigeMiller]

---

@Sujithpeta wrote:

@Reeza I tried the code but it's throwing error.

I also tried changing the YYMMDDN10. to YYMMDDN8. I had the same error.

---

Please copy and paste the SASLOG as text (not as an image) into the {i} window.