Hello,  I have a numeric variable that is 6 numbers in length. I'd like to use SQL to only keep the numbers that are 3 digits long. So, for example, I would keep 123 but not 1234 or 12345 or 123456.    Thanks.  ... View more

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   ... View more