topic Re: An error occurred executing the workspace job "input method" in New SAS User

An error occurred executing the workspace job "input method"

vinayp913 — Wed, 21 Sep 2022 08:49:30 GMT

Integration technologies failed to submit the code. [Error] Failed to transcode data from utf-16le to wlatin1 encoding because it contained character which are not supported by your SAS session encoding.

that's the dataset i am trying to run

Data Ex_3;
infile '‪‪D:\example_3.txt';
Input Name$ 1-7 height 9-10 weight 12-14;
BMI=700*weight/(height*height);
output;
run;

Re: An error occurred executing the workspace job "input method"

ballardw — Wed, 21 Sep 2022 15:10:12 GMT

See if this helps:

Data Ex_3;
infile '‪‪D:\example_3.txt' encoding='utf-16le';
Input Name$ 1-7 height 9-10 weight 12-14;
BMI=700*weight/(height*height);
output;
run;

This should tell SAS that the external file is that encoding and set up how to read it.

You may need to increase the number of "columns" read as some of the UTF-16 characters may take up more space when converted. You may also get some very interesting results depending on the actual source.

For what it is worth one of the first UTF-16 files I encountered had every character when read preceded by a space. What looked like "Fred" in the file was read as " F r e d".

Re: An error occurred executing the workspace job "input method"

Tom — Wed, 21 Sep 2022 15:38:33 GMT

Two issues.

1) WLATIN1 is a single byte encoding. So it can only represent 256 distinct characters. At least one of the characters in your file is not one of those characters. To fix this you need to start SAS using a different encoding. How to do that differs based on how you are running SAS. If you have it installed on your PC look for "SAS 9.4 (Unicode support)" icon in your Start menu.

2) Fixed column input will not work well with Unicode characters. Some characters use more than one byte, which will mess up the column counting. Does the data contain a delimiter between the fields? Post some of the lines of data as plain text instead of as an attachment. Just open the text file in a text editor and copy a few lines and paste them into the pop-up window that appears when you click the Insert Code icon in the forum editor (the icon looks like the character string < / > ).