Hello wizzards!
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.
| 19 mei 2029 |
| 21 jul 2046 |
| 24 jun 2042 |
| 23 aug 2034 |
| 04 jun 2038 |
Help is appreciated!
Thanks in advance.
Use your locale, and the NLDATE informat:
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
;
Use your locale, and the NLDATE informat:
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
;
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Explore Now →Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.