Changing the date from dutch to English

[siddhu1]

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

[japelin]

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.

[Sajid01]

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. 

[sbxkoenk]

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

[Kurt_Bremser]

Please show your code.