topic Re: Dutch DATETIME LONG to SAS Date? in SAS Procedures

Dutch DATETIME LONG to SAS Date?

MijnSGS2 — Tue, 09 Oct 2018 15:55:52 GMT

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.

Re: Dutch DATETIME LONG to SAS Date?

Kurt_Bremser — Tue, 09 Oct 2018 16:00:18 GMT

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

Re: Dutch DATETIME LONG to SAS Date?

data_null__ — Tue, 09 Oct 2018 16:18:19 GMT

 
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.

Re: Dutch DATETIME LONG to SAS Date?

novinosrin — Tue, 09 Oct 2018 17:03:39 GMT

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!

Re: Dutch DATETIME LONG to SAS Date?

data_null__ — Tue, 09 Oct 2018 18:09:26 GMT

@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.

Re: Dutch DATETIME LONG to SAS Date?

MijnSGS2 — Fri, 12 Oct 2018 12:09:13 GMT

This is master code!
Thanks so much! 🙂