topic Re: Extracting and converting dates in strings to new date string in New SAS User

Extracting and converting dates in strings to new date string

NickK — Mon, 20 Jan 2020 16:39:46 GMT

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

Re: Extracting and converting dates in strings to new date string

novinosrin — Mon, 20 Jan 2020 16:59:36 GMT


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;

Re: Extracting and converting dates in strings to new date string

NickK — Mon, 20 Jan 2020 17:50:39 GMT

Thanks. Works perfectly.