Importing Text as Date and Ignore Time

Reply
Frequent Contributor
Posts: 92

Importing Text as Date and Ignore Time

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

Respected Advisor
Posts: 3,066

Re: Importing Text as Date and Ignore Time

Import it as a date-time value, then apply the DATEPART function to it to make it a date value.

--
Paige Miller
Ask a Question
Discussion stats
  • 1 reply
  • 72 views
  • 2 likes
  • 2 in conversation