topic Re: How to ignore eof character in proc import in SAS Programming

How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 09:41:50 GMT

Hello,

I have problem with my proc import. I have this log if when importing an excel file with proc import :

WARNING: Some character data was lost during transcoding in column: LibellÃ© partic

Please can someone help me to ignore this warning. there is an option to use in proc import ?

Thks

Re: How to ignore eof character in proc import

Kurt_Bremser — Thu, 31 Mar 2022 10:15:07 GMT

Please show us the complete log, so we know what kind of file you are importing.

Re: How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 12:06:55 GMT

am importing an excel file with proc import an the log is :

WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 31.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 33.

Re: How to ignore eof character in proc import

andreas_lds — Thu, 31 Mar 2022 13:27:03 GMT

Transcoding errors often appear if the sas session uses an outdated encoding like latin1 instead of utf-8.

Btw. you still have not posted the complete log.

Re: How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 13:38:53 GMT

for this, i use filename stament and set enoding="utf-8" but it doesn't work

Re: How to ignore eof character in proc import

Kurt_Bremser — Thu, 31 Mar 2022 14:15:04 GMT

Complete

Re: How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 14:21:30 GMT

..???

Re: How to ignore eof character in proc import

Kurt_Bremser — Thu, 31 Mar 2022 14:27:54 GMT

It seems you have trouble with the meaning of the word "complete", so I sent you the online available dictionary entry.

Re: How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 14:39:28 GMT

ohh it's all i have in the log : WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 447985.

Re: How to ignore eof character in proc import

ballardw — Thu, 31 Mar 2022 14:50:38 GMT

COMPLETE LOG means copy the submitted code, which would start with Proc , to include all of the messages and the time the procedure took to execute.

Re: How to ignore eof character in proc import

Kurt_Bremser — Thu, 31 Mar 2022 14:51:34 GMT

If your log does not inlcude the code that was run, make sure that

options source;

is set, and that you do not run your code as part of a macro.

Re: How to ignore eof character in proc import

ajulio4 — Thu, 31 Mar 2022 14:58:48 GMT

31 proc import out=tes
32 datafile =ext
33 dbms=xlsx
34 replace;
35 getnames=yes;
36 run;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with
options MSGLEVEL=I.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 31.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 33.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 34.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 35.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 36.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 37.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 38.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 39.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 40.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 41.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 42.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 43.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 44.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 45.
WARNING: Some character data was lost during transcoding in column: LibellÃ© particularitÃ© Ã©metteur at obs 48.

Re: How to ignore eof character in proc import

Tom — Thu, 31 Mar 2022 15:17:22 GMT

Start SAS using "Unicode support" which just means using ENCODING='utf-8'.

How to do that depends on how you are running SAS.

If you are using SAS/Studio or Enterprise Guide as the front end tool for submitting SAS code then make sure you are connected to a SAS application server that is using unicode support.

If you are using SAS on Windows then there should be Start menu entry/icon for running SAS with Unicode support.

If you are using SAS from the command line you might be able to just add the -encoding option to the command line, but you might also have a different config file you point the -config option at instead.

Re: How to ignore eof character in proc import

Ksharp — Fri, 01 Apr 2022 13:39:44 GMT

Two options: either use Unicode SAS (utf-8 encoding) to import this excel or Save this excel as CSV and import this csv again.