We have a new data supplier that is sending us data with a combined Month_Entry_Date variable. The variable has data which is month and time as:
4/1/2018 12:00:00 AM
I only want to read the date component (4/1/2018) and ignore the rest and have SAS make it a date variable. The user has tried this with EG to no success. I suspect this may need to be programmed instead.
Any ideas?
-Bill