Dear All,
I want to extract all dates from term variable:
The data in term vriables is:
Days of 08 April 19
count on 10 May 2019, 05 May 2018, 08-Jan-2005
apply i.e. 08 April 19 and 10-Jan-2005
I want ro extract all dates from above variable, in one or multiple vriables using regex or perl regular expression
I tried the following program but I am geting only last date
data cd.new;
set cd.Date_ex;
dsdate=prxchange('s/.*(\d{2}(\s+|-)\w+(\s+|-)\d{2,4}).*/\1/', 1, term);
run;
Output:
08 April 19
08-Jan-2005
10-Jan-2005