topic Re: changing the encoding of my SAS session in SAS Programming

changing the encoding of my SAS session

Emma_at_SAS — Wed, 17 Mar 2021 04:08:48 GMT

I guess my SAS session has encoding WLATIN1, while my SAS data file has UTF-8 encoding. I need to change my SAS session's encoding to UTF-8. I tried the following code but did not work. I appreciate it if you may guide me. Thanks!

data SAS_data; 
	set name_lib.data;  
	ENCODING='UTF-8'; 
	OPTIONS NOFMTERR; 
	run;

NOTE: Data file name_lib.data.DATA is in a format that is native to another host, or the file encoding does not match the

session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce

performance.

ERROR: Some character data was lost during transcoding in the dataset name_lib.data. Either the data contains characters

that are not representable in the new encoding or truncation occurred during transcoding.

proc options option=config; run;
proc options group=languagecontrol; run;
proc options option=encoding; run;

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         proc options option=config; run;
 
     SAS (r) Proprietary Software Release 9.4  TS1M7
 
  CONFIG=( "C:\SAS\Config\Lev1\SASApp\WorkspaceServer\sasv9.cfg" "C:\SAS\Config\Lev1\SASApp\sasv9.cfg" "C:\Program 
 Files\SASHome\SASFoundation\9.4\sasv9.cfg" "C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg" 
 "C:\SAS\Config\Lev1\SASApp\sasv9_usermods.cfg" "C:\SAS\Config\Lev1\SASApp\WorkspaceServer\sasv9_usermods.cfg" )
                    Specifies the configuration file that is used when initializing or overriding the values of SAS system options.
 NOTE: PROCEDURE OPTIONS used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 74         proc options group=languagecontrol; run;
 
     SAS (r) Proprietary Software Release 9.4  TS1M7
 
 
 Group=LANGUAGECONTROL
  DATESTYLE=MDY     Specifies the sequence of month, day, and year when ANYDTDTE, ANYDTDTM, or ANYDTTME informat data is ambiguous.
  DFLANG=LOCALE     Specifies the language for international date informats and formats.
  DSCAS             Runs the DATA step on the CAS server.
  EXTENDOBSCOUNTER=YES
                    Specifies whether to extend the maximum number of observations in a new SAS data file.
  LOCALEDATA=SASLOCALE
                    Specifies the location of the locale database.
  NOLOGLANGCHG      Disables changing the language of the SAS log when the LOCALE= option is changed.
  NOLOGLANGENG      Write SAS log messages based on the values of the LOGLANGCHG, LSWLANG=, and LOCALE= options when SAS started.
  LSWLANG=LOCALE    Specifies the language for SAS log and ODS messages when the LOCALE= option is set after SAS starts.
  MAPEBCDICTOASCII= Specifies the transcoding table that is used to convert characters from ASCII to EBCDIC and EBCDIC to ASCII.
  NONLDECSEPARATOR  Disables formatting of numeric output using the decimal separator for the locale.
  NOODSLANGCHG      Disables changing the language of the SAS message text in ODS output when the LOCALE option is set after start 
                    up.
  PAPERSIZE=LETTER  Specifies the paper size to use for printing.
  RSASIOTRANSERROR  Displays a transcoding error when illegal values are read from a remote application.
  TIMEZONE='GMT-04:00'
                    Specifies a time zone.
  TRANTAB=(lat1lat1,lat1lat1,wlt1_ucs,wlt1_lcs,wlt1_ccl,,,)
                    Specifies the translation table catalog entries.
  URLENCODING=SESSION
                    Specifies whether the argument to the URLENCODE function and to the URLDECODE function is interpreted using the 
                    SAS session encoding or UTF-8 encoding.
  NODBCS            Disables double-byte character sets.
  DBCSLANG=NONE     Specifies a double-byte character set language.
  DBCSTYPE=NONE     Specifies the encoding method to use for a double-byte character set.
  ENCODING=WLATIN1  Specifies the default character-set encoding for the SAS session.
  LOCALE=EN_US      Specifies a set of attributes in a SAS session that reflect the language, local conventions, and culture for a 
                    geographical region.
  NONLSCOMPATMODE   Encodes data using the SAS session encoding.
 NOTE: PROCEDURE OPTIONS used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 75         proc options option=encoding; run;
 
     SAS (r) Proprietary Software Release 9.4  TS1M7
 
  ENCODING=WLATIN1  Specifies the default character-set encoding for the SAS session.
 NOTE: PROCEDURE OPTIONS used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 76         
 77         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 89

Re: changing the encoding of my SAS session

japelin — Wed, 17 Mar 2021 04:35:48 GMT

Do you need to process UTF-8 encoding data sets within the current session?
The easiest way is to use the SAS Unicode version.

Re: changing the encoding of my SAS session

SASKiwi — Wed, 17 Mar 2021 05:38:23 GMT

You just need to add the following line to your file:

C:\SAS\Config\Lev1\SASApp\sasv9_usermods.cfg

-ENCODING = UTF-8

Re: changing the encoding of my SAS session

Ksharp — Wed, 17 Mar 2021 10:56:50 GMT

If your sas was stand alone PC version . Try Unicode version sas.

Re: changing the encoding of my SAS session

Emma_at_SAS — Wed, 17 Mar 2021 13:30:05 GMT

Thanks everyone! Using the SAS(Unicode) session was the easiest way I could use to read my whole data.

In this SAS environment (Unicode), I see an extra column as ENCODING (Char). Is everything in this environment work similar to the regular SAS(DBCS) session and saved normally to be used in the other environment later? Is there anything I should be careful about?

Thanks!

Re: changing the encoding of my SAS session

Emma_at_SAS — Wed, 17 Mar 2021 13:31:37 GMT

Thanks, SASKiwi. How do I exactly add ENCODING = UTF-8 to my file?

Re: changing the encoding of my SAS session

Kurt_Bremser — Wed, 17 Mar 2021 13:39:43 GMT

@Emma_at_SAS wrote:
Thanks, SASKiwi. How do I exactly add ENCODING = UTF-8 to my file?

Edit it with Notepad. SAS cfg files are simple text files.

Re: changing the encoding of my SAS session

Ksharp — Thu, 18 Mar 2021 11:00:46 GMT

"Is everything in this environment work similar to the regular SAS(DBCS) session "
Yes.

"and saved normally to be used in the other environment later?"
No. only for utf-8 encoding environment .

Re: changing the encoding of my SAS session

Emma_at_SAS — Thu, 18 Mar 2021 14:24:14 GMT

"and saved normally to be used in the other environment later?"
No. only for utf-8 encoding environment.
--> So, the code from the SAS(UNICODE) works well for two environments: SAS(UNICODE) and the UTF-8 encoding environment.

Re: changing the encoding of my SAS session

Emma_at_SAS — Thu, 18 Mar 2021 14:25:32 GMT

Thank you, everyone!

Re: changing the encoding of my SAS session

Ksharp — Fri, 19 Mar 2021 10:17:28 GMT

SAS CODE could work at any encoding , But Data does not .
SAS(UNICODE) IS JUST (equal) UTF-8 encoding environment.