Hi, I have a database of 150 cancer patients. I calculated the expected disease assessment dates that occurs every 28 days for the next 3 years. The site performed disease assessment on expected dates but missed a few dates. i have my input in 2 different tables. Table 1: calculated disease assessment dates for 3 years. Table 2 : Site assessment dates. My output should capture the missing expected disease assessment dates/ incorrect assessment dates. If the date matches, it should give a blank column, else it should give the missing/incorrect date. I am trying out various techniques using loops and arrays but I end up getting huge output. Output should be restricted to one row per subject. Table 1: Subject pd_1 pd_2 pd_3 pd_4 ... pd_36 100 21NOV2013 19DEC2013 16JAN2014 3FEB2014 Table 2: Subject Response_Date 100 2013-11-21 100 2013-12-19 100 2014-01-16 100 2014-02-14 100 2014-03-13 Output: Subject pd_1 pd_2 pd_3 pd_4 100 03Feb2014
... View more