topic Re: Changing the date from dutch to English in SAS Programming

Changing the date from dutch to English

siddhu1 — Mon, 21 Mar 2022 11:53:34 GMT

Hi Team,

When I was trying to execute the program, the values in the columns m_date and c_date , they are coming in dutch language as:

21 februari 2022 and 02 maart 2022

Can anyone suggest me on this.

Thanks & Regards,

Siddhartha

Re: Changing the date from dutch to English

japelin — Mon, 21 Mar 2022 12:07:39 GMT

Are the variables m_date and c_date character types? Or is it a numeric type?
And what do you want to do with this date in Dutch notation, e.g. 21FEB2022?
If it is a character type, you can use the input function to convert it to a SAS date value, and if it is a numeric type, you can apply a different format to display it as desired.

Re: Changing the date from dutch to English

Sajid01 — Mon, 21 Mar 2022 14:44:08 GMT

Hello @siddhu1
SAS stores dates with reference to January 1,1960. So it is easy to display the date as per your need.
If you are getting Dutch dates / times then either your system is set to use that time zone or the tz option has been used to set that particular time zone in the code. Using the code example below you can display the date/ time values as per per your needs

option tz='America/Detroit';
data _Null_;
format dt1 datetime20.;
dt1=datetime();
put dt1=;
run;
option tz='Europe/Amsterdam';
data _Null_;
format dt1 datetime20.;
dt1=datetime();
put dt1=;
run;

If you do not want to follow this approach, then discuss the issue with your SAS Administrator / OS Administrator.

Re: Changing the date from dutch to English

sbxkoenk — Mon, 21 Mar 2022 15:29:48 GMT

Hello,

Let's not forget Dutch is a beautiful language and the Unites States had almost spoken Dutch if history had been a little different. 😉. (I am Flemish / Belgian by the way, but we also speak Dutch)

Apart from that ...
Check if your numeric variable has a Dutch (European) date format, like :
* EURDFWKXw. Format
* EURDFWDXw. Format
* EURDFDWNw. Format

Also check the value of your LOCALE= option.
And run this code (and check the LOG):

proc options GROUP=LANGUAGECONTROL ;
run;

Koen

Re: Changing the date from dutch to English

Kurt_Bremser — Mon, 21 Mar 2022 15:44:07 GMT

Please show your code.