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
;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.