However, the datetime format in the xml file is a bit strange, and comes in as text. The informat E8601DT. will do the translation to a SAS datetime.
FORMAT NEWDATE DATETIME23. ;
(or TEMPEXPDATE, as the case may be)
Here's where I'm stuck: 8 of the 15 tables have a datetime variable. In one table, it is named TEMPEXPDATE, and it is DATE in the rest. I can get a listing of the tables that contain "DATE" as part of the variable name from SASHELP.VCOLUMN.
PROC SQL NOPRINT ;
CREATE TABLE DATENAMES AS
WHERE LIBNAME='EQUIP' AND NAME CONTAINS 'DATE' ;