Implemented the logic - num to char date    proc contents data = temp.dov out = con noprint; run;   data con; set con; dp1 = datepart(crdate); call symput ('date',put(dp1,date9.)); run; %put &date;     data dov_1;  set dov_new;  by subject instancename;  if last.subject;  doe = "&date";  vd = put(datepart(visitdt),date9.);  day_diff = intck("day", vd, "&date");  if day_diff > 105;  drop visitdt; run; ... View more

The code provided should have worked so either your data isn't as specified or you did something wrong. How did you use the code provided? In a query builder or as a data step? What did your log say?   Verify the type and format of your variable.   Run a proc contents and post the results for that variable.      data test; length x $10.; x="2016-10-12"; y=input(x, yymmdd10.); format y date9.; run; proc print data=test; run;     ... View more