https://communities.sas.com/t5/SAS-Programming/Importing-Text-as-Date-and-Ignore-Time/m-p/461029#M284774 <P>We have a new data supplier that is sending us data with a combined Month_Entry_Date variable.&nbsp; The variable has data which is month and time as:</P><P>&nbsp;</P><P>4/1/2018 12:00:00 AM</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Any ideas?</P><P>&nbsp;</P><P>-Bill</P> Wed, 09 May 2018 14:05:46 GMT BCNAV 2018-05-09T14:05:46Z https://communities.sas.com/t5/SAS-Programming/Importing-Text-as-Date-and-Ignore-Time/m-p/461029#M284774 <P>We have a new data supplier that is sending us data with a combined Month_Entry_Date variable.&nbsp; The variable has data which is month and time as:</P><P>&nbsp;</P><P>4/1/2018 12:00:00 AM</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Any ideas?</P><P>&nbsp;</P><P>-Bill</P> Wed, 09 May 2018 14:05:46 GMT https://communities.sas.com/t5/SAS-Programming/Importing-Text-as-Date-and-Ignore-Time/m-p/461029#M284774 BCNAV 2018-05-09T14:05:46Z https://communities.sas.com/t5/SAS-Programming/Importing-Text-as-Date-and-Ignore-Time/m-p/461031#M284775 <P>Import it as a date-time value, then apply the DATEPART function to it to make it a date value.</P> Wed, 09 May 2018 14:08:07 GMT https://communities.sas.com/t5/SAS-Programming/Importing-Text-as-Date-and-Ignore-Time/m-p/461031#M284775 PaigeMiller 2018-05-09T14:08:07Z