topic How to change encoding for a dataset? in SAS Enterprise Guide

How to change encoding for a dataset?

Derdavos — Wed, 05 Apr 2017 11:48:29 GMT

Hey guys! 🙂

I would like to know if there is any way to change the dataset's encoding. Currently it is in ASCII (or utf-16Ie (I don't know what is that)), which is - I guesss - not supported by Enterprise guide, because it's always throwing an error when I want to make descriptive statistics on (for example) invoice. It says that it is not UTF-8 (to be precise, it says: "failed to transcode data from utf-16Ie(...)"). So I have to change the encoding.

And If I am here I would like to ask that, what should I do if it drops error for an importation? I wanted to import the sashelp.class, but it keep yelling that it is NOT a dataset... Any guess?

Thank you for your answers. 🙂

Re: How to change encoding for a dataset?

Derdavos — Wed, 05 Apr 2017 12:08:54 GMT

I solved it for myself. 🙂 Here is the method:

1. Go to the location of your SAS.

2. Then go into SASFoundation.

3. Click on 9.4 folder, and after it search the sasv9 file.

4. Open it with ".txt" editor (notepad, note++ etc).

5. Write over th "/en/" to "/u8/".

It will solve ALL the problems. 🙂

Re: How to change encoding for a dataset?

krisraa — Thu, 21 Sep 2017 19:23:05 GMT

I already have the utf-8 as encoding in the config file, but still getting the error as below:

ERROR: Some character data was lost during transcoding in the data set
       libref.datasetname. Either the data contains characters that are not
       representable in the new encoding or truncation occurred during transcoding.

last section of my config file looks like this:

-FONTSLOC C:\Windows\Fonts
-SET MYSASFILES "?FOLDERID_Documents\My SAS Files\9.4"
-SASUSER "?FOLDERID_Documents\My SAS Files\9.4"
-WORK "!TEMP\SAS Temporary Files"
-MEMSIZE 2G
-SORTSIZE 1G
-TEXTURELOC !SASROOT\common\textures
-SET SASCFG "C:\Program Files\SASHome\SASFoundation\9.4\nls\u8"
-DBCS 
-LOCALE en_US
-ENCODING UTF-8
-SET SAS_NO_RANDOM_ACCESS "1"
-MAPS !SASROOT\maps
-MAPSGFK !SASROOT\mapsgfk
-MAPSSAS !SASROOT\maps
-APPLETLOC "C:\Program Files\SASHome\SASGraphJavaApplets\9.4"

Can you point what is missing or what needs to be amended?

-Krisraa