BookmarkSubscribeRSS Feed
Viktory
Calcite | Level 5

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!

5 REPLIES 5
CaseySmith
SAS Employee

Hi!  When you say "in my views", exactly which UI features of EG are you referring to?  The Query Builder?  Filter and Sort?  The data grid?  I ran this code in EG 7.11 (with EG display language set to Swedish):

data blah;
infile datalines dsd;
input color $;
datalines;
Ljusröd
Mörkröd
;
run;


And then used the resultant data set in the Query Builder and in Filter and Sort, and the values displayed as expected in the UI:
Untitled.png

Also, submit this to see what your server locale and encoding options are set to:

proc options group=languagecontrol;
run;

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

Viktory
Calcite | Level 5

Thanks for the replies!

By views I mean SAS tables which are "views" towards the database, I'm not technical or proficient in English enough to explain it better. But basically it's tables containing national characters which are displayed without them in SAS EG.

I ran proc options in and it returned:

ENCODING=WLATIN1  Specifies the default character-set encoding for the SAS session.

LOCALE=SV_SE           Specifies a set of attributes in a SAS session that reflect the language,

                                      local conventions, and culture for a geographical region.

jakarman
Barite | Level 11

Eguide is supporting utf8 that is for all languages. There cannot be a problem with that.

Eguide is connecting to a SAS session running in some language setting it can be utf8 in multi byte setting or a classic single byte one to be configured with a language encoding.

That Sas session is connecting to the dbms client with a sas/access interface. That dbms client is going to the dbms.

In your dbms setup it set back to a classic 7bit Ascii setting. Ask the person that did the server installation why he did that and not the nls settings.

---->-- ja karman --<-----
Kurt_Bremser
Super User

Compare the settings of the other clients, where the characters work, with yours. And also have a look at the DB client setup on those machines. You may have some conversion going on there before the data actually reaches SAS.

jakarman
Barite | Level 11

Ok your sas session is a single byte Latin1 se encoding.

That is not the problem. I was asking for the dbms client and sas/access combination. The dbms will also be no problem. It is in between those.

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1955 views
  • 0 likes
  • 4 in conversation