Hi! I have this problem where the national Swedish characters å, ä, ö in our database are displayed as a, a, o in my views in SAS EG. For example, two of the values of the variable COLOR is 'Ljusröd' and 'Mörkröd' but in my views and when i write SQL querys they are listed as 'Ljusrod' and 'Morkrod'. I know the ö is there in the database because on other SAS clients at the company the national characters are present. Sometimes when i try to select entries where COLOR='Ljusrod' I get no results no matter if I write 'Ljusröd' or 'Ljusrod' which is very wierd, because inte the view there are plenty of 'Ljusrod'. I have both Swedish and English versions of SAS 9.4 installed though I'm not sure where to check which one EG uses. The interface in EG is in Swedish. I have tried the options validvarname=any and locale=Swedish, but to no avail. Does anyone have any idea what could be wrong? Thanks!
... View more