Extracting and converting dates in strings to new date string

[NickK]

I have some code which works to extract the Last Modified date from an excel file:

data last_mod_date;

  rc = filename("onefile","F:\test.xlsx");

  fid=fopen("onefile"); /*fid is the file-id*/

  Mod_Date=finfo(fid,'Last Modified');

  rc = fclose(fid);

  rc = filename("onefile");

run;

The data is stored as at 200 character length as the following 

January 14, 2020 12:25:02

Now I want to take the above and convert it to the following string

YYYYMMDD_HHMM

I've tried several difference methods to try and extract the month/day/year/hours/minutes individually but none of them seem to work. Any ideas? 

Note; I need this to work for any string date I extract (dates will be after January 1, 2020 if that helps) 

Thanks

[novinosrin · Accepted solution]

data test;
dt='January 14, 2020 12:25:02';/*string*/
num_dt=input(dt,anydtdtm35.);/*numeric datetime value*/
/*Extract date value, time value and concatenate to a new string value*/
want_date=cats(put(datepart(num_dt),yymmddn8.),'_',compress(put(timepart(num_dt),hhmm.),':'));
drop num_dt;
run;

[NickK]

Thanks. Works perfectly.