https://communities.sas.com/t5/SAS-Enterprise-Guide/Translate-Dutch-date-to-SAS-date/m-p/790917#M40175 <P>Use your locale, and the NLDATE informat:</P> <PRE><CODE class=" language-sas">options locale = nl; data want; input date nldate11.; format date yymmdd10.; datalines; 19 mei 2029 21 jul 2046 24 jun 2042 23 aug 2034 04 jun 2038 ;</CODE></PRE> Wed, 19 Jan 2022 15:37:05 GMT Kurt_Bremser 2022-01-19T15:37:05Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Translate-Dutch-date-to-SAS-date/m-p/790912#M40174 <P>Hello wizzards!</P><P>&nbsp;</P><P>I am stuck trying to translate a Dutch date format to a SAS formatted date. Is it possible to translate data formatted like in the table to the DDMMYYD10. format? Preferable in the query builder but SAS script is also helpful.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>19 mei 2029</TD></TR><TR><TD>21 jul 2046</TD></TR><TR><TD>24 jun 2042</TD></TR><TR><TD>23 aug 2034</TD></TR><TR><TD>04 jun 2038</TD></TR></TBODY></TABLE><P><BR />Help is appreciated!&nbsp;</P><P>&nbsp;</P><P>Thanks in advance.</P> Wed, 19 Jan 2022 15:27:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Translate-Dutch-date-to-SAS-date/m-p/790912#M40174 WtotheW 2022-01-19T15:27:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Translate-Dutch-date-to-SAS-date/m-p/790917#M40175 <P>Use your locale, and the NLDATE informat:</P> <PRE><CODE class=" language-sas">options locale = nl; data want; input date nldate11.; format date yymmdd10.; datalines; 19 mei 2029 21 jul 2046 24 jun 2042 23 aug 2034 04 jun 2038 ;</CODE></PRE> Wed, 19 Jan 2022 15:37:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Translate-Dutch-date-to-SAS-date/m-p/790917#M40175 Kurt_Bremser 2022-01-19T15:37:05Z