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.
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.
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 ................
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.