Dutch DATETIME LONG to SAS Date?

[MijnSGS2]

Hi all,

Is it possible in SAS to convert a Dutch datetime like this one:

09 oktober 2018 16:50:10 uur

To a SAS date like: 21466

or to SAS seconds like this: 1854723010?

I tried datepart(my_date_variable) but no luck..

Any help?

Thanks in advance.

[Kurt_Bremser]

Do you have access to the raw datetime value in the source?

[data_null__ · Accepted solution]

---

123  data _null_;
124     options locale=Dutch_Netherlands;
125     y=input('09 oktober 2018 16:50:10 uur', nldatm30.);
126     put y= y=datetime22.;
127     run;

y=1854723010 y=09OCT2018:16:50:10

@MijnSGS2 wrote:

Hi all,

Is it possible in SAS to convert a Dutch datetime like this one:

09 oktober 2018 16:50:10 uur

To a SAS date like: 21466

or to SAS seconds like this: 1854723010?

I tried datepart(my_date_variable) but no luck..

Any help?

Thanks in advance.

---

[novinosrin]

My oh my @data_null__  Sir, is there anything that you do not know about. Jeez, can't believe that knowledge transcends geography info. Hats off!

[data_null__]

---

@novinosrin wrote:

My oh my @data_null__  Sir, is there anything that you do not know about. Jeez, can't believe that knowledge transcends geography info. Hats off!

---

@novinosrin It is all about the documentation.   I know SAS has national language support and that I needed an in-format.  I copied the example and used @MijnSGS2 data. 

[MijnSGS2]

This is master code!
Thanks so much! 🙂