topic Problems importing data to SAS in SAS Programming

Problems importing data to SAS

Sagie — Sat, 25 Mar 2017 08:18:10 GMT

Hello,
I am using SAS Enterprise Guide and I have a problem importing data in to SAS, when ever I try to import data I get this error
"failed to transcode data from utf-16le to wlatin 1 encoding because it contained characters which are not supported by your SAS session encoding".
I tried a few different files and I always get the same error so its not a problem with a specific file,does anybody have any idea what I need to do?

Re: Problems importing data to SAS

Ksharp — Sat, 25 Mar 2017 12:32:50 GMT

Specify this encoding for this file.

filename x 'c:\xx.csv' encoding='utf-16le';
proc import datafile=x out=have ...........

Re: Problems importing data to SAS

Cynthia_sas — Sat, 25 Mar 2017 13:52:55 GMT

In addition, if this is happening on multiple different files, then you might need to change the transcoding of your whole session ... especially if you are using SAS on a server. See this Tech Support note: http://support.sas.com/kb/32/007.html

cynthia