topic Re: Error with data import in SAS Enterprise Guide

Error with data import

Dariash — Wed, 03 Apr 2019 13:56:08 GMT

Did not find a solution about my error. Can somebody help me? My error is:

an error occurred executing the workspace job "the import data wizard (Intermediate submit)"

Integration technologies failed to submit the code. [Error] Failed to transcode data from utf-16le to wlatin1 encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accomodate the data that you want to process. A portion of the source string, in hex representation is:

[None] 64fcb4: 3b 00 2a 00 27 00 3b 00 2a 00 22 00 3b 00 2a 00

etc

I am trying to import usual excel file and my friends did it easily.

Tell me instructions what should i do please. Looking forward for your answer.

Re: Error with data import

Kurt_Bremser — Wed, 03 Apr 2019 14:06:53 GMT

Copy the file to the server with the Copy Files task, and then use a data step with encoding="utf-16" in the infile statement.

Re: Error with data import

Ksharp — Wed, 03 Apr 2019 14:11:59 GMT

Try to Save this excel file into CSV file and use ENCODING= options.

filename x 'c:\........have.csv' encoding=' utf-16le ';

proc import datafile=x ................