Hi, I appreciate your help. I'm trying to filter out the records on the basis of a certain cutoff date i.e. I wish to create a subset of data after a certain date, let's say : 1st August 2019. Here is my code: data cmarerr; set bcccparp.bcc_cmar_subm_event_details_err; where ERROR_TREASON like '%Patient Date of Birth is not valid%' and CREATE_TIMESTAMP > '01AUG2019'd; run; It produces No errors or warnings but the second condition of date doesn't seem to work as it doesn't filter out other previous entries.
... View more