Invalid argument to function YRDIF

_maldini_ — Thu, 14 Apr 2016 21:42:32 GMT

I'm trying to calculate the difference in years between two dates using the YRDIF function and the following syntax:

DATA want;
  SET have;
  Yrdif_test = YRDIF(Part_RDATE, BH_Accomplished_Date, "Actual");
RUN;

I am getting an "invalid argument" warning and all the values are missing.

The informats for these two dates are different.

Part_RDATE = mmddyy10

BH_Accomplished_Date=mdyampm25.2 (includes time)

The documentation makes no reference to differences in informats, or dates where one includes time.

A portion of the data is attached. As is the log. Thanks for your help.

Re: Invalid argument to function YRDIF

SASKiwi — Thu, 14 Apr 2016 22:01:20 GMT

The documentation states that both start and end dates are both SAS date values not datetime. This should correct your statement:

DATA want;
  SET have;
  Yrdif_test = YRDIF(Part_RDATE, datepart(BH_Accomplished_Date), "Actual");
RUN;