Hi, I am trying to perform a query that returns the dates less than/prior to the current date in the column "date". This should form a new column called "past".
data have;
input Subject Type :$12. Date &:anydtdte.;
format date yymmdd10.;
datalines;
500 Initial 15 AUG 2017
500 Initial 15 AUG 2017
500 Followup 15 AUG 2018
428 Followup 15 AUG 2018
765 Seventh 3 AUG 2018
500 Followup 3 JUL 2018
428 Initial 3 JUL 2017
765 Initial 20 JUL 2019
610 Third 20 AUG 2019
610 Initial 17 Mar 2018
;