topic Re: ERROR when importing a txt file, any clues? in SAS Enterprise Guide

ERROR when importing a txt file, any clues?

chemicalab — Fri, 20 May 2016 10:11:44 GMT

Hi all,

I encounter this type of error (see attached) when i am trying to import (via menu and import wizard) a txt file into EG.

I havent had this problem before so i am kinda stuck.

Thank you in advance.

Re: ERROR when importing a txt file, any clues?

Kurt_Bremser — Fri, 20 May 2016 10:19:51 GMT

It means that your text file contains UTF-16 characters that cannot be transcoded (converted) to the wlatin1 encoding that your SAS session (workspace server) is configured in.

You either need to set up the workspace server so that it uses UTF encoding, or convert those special characters in the text file before you submit it to the import task.

Re: ERROR when importing a txt file, any clues?

chemicalab — Fri, 20 May 2016 10:24:14 GMT

OK, how can i do the first option? because when colleagues import the same exact file with the same licensed software they dont encounter this error.

Kind regards

Re: ERROR when importing a txt file, any clues?

Kurt_Bremser — Fri, 20 May 2016 10:58:37 GMT

Look closely at your error message, it hints at what needs to be set.

See the documentation for the NLS system options.

While LOCALE= can be changed dynamically, ENCODING= needs to be set at session start, either via commandline (can be set in the metadata or USERMODS_OPTIONS in WorkspaceServer_usermods.sh) or in the config file (sasv9_usermods.cfg).

Re: ERROR when importing a txt file, any clues?

chemicalab — Fri, 20 May 2016 11:55:24 GMT

Any good example on doing that?

Re: ERROR when importing a txt file, any clues?

ChrisHemedinger — Fri, 20 May 2016 13:14:51 GMT

As a quick workaround, try applying the option on the Advanced tab, "Remove characters that can cause transmission errors..."

Re: ERROR when importing a txt file, any clues?

chemicalab — Fri, 20 May 2016 13:32:30 GMT

I have tried that but the result is the same, thank you both for your input, i think i will have to do it via commandline

Kind regards