import file -import wizard

Ronein — Mon, 01 Jul 2024 09:22:11 GMT

Hello

I wan to import CSV Excel file.

The file is saved as type cv comma delimited.

I am using import wizard and receive an error.

What should I do in order to solve it and import the file?

Re: import file -import wizard

rudfaden — Mon, 01 Jul 2024 09:26:30 GMT

Probaly make the eecoding of your csv file and SAS session match.

Re: import file -import wizard

Kurt_Bremser — Mon, 01 Jul 2024 10:04:19 GMT

Use the Copy Files task to upload the file, then write the DATA step yourself with ENCODING=UTF8 in the INFILE statement.

Re: import file -import wizard

Tom — Mon, 01 Jul 2024 12:19:05 GMT

The message means that the file is using UTF-8 characters and your SAS session is running with a single byte encoding that does not have any way to represent some of the UTF-8 characters that are in the file.

If you run SAS using UTF-8 encoding instead then the import Wizard should work.

Otherwise upload the file to the machine where SAS is actually running and just read it yourself. If you still want to use a single byte encoding the read the file using ENCODING='ANY' option in the INFILE statement. You can then use functions like KCVT, HTMLENCODE() and TRANWRD to convert the UTF-8 characters that are not included in your single byte encoding into multiple character strings.

For example here is an example of how to convert UTF-8 characters in a variable that are not valid in LATIN1 into multiple character strings that HTML will recognize as those same characters.

*----------------------------------------------------------------------------;
* Convert any extended or control characters to HTML strings ;
*----------------------------------------------------------------------------;
  array _character_ _character_;
  do over _character_;
    do until(_n_=0);
      _n_=kverify(_character_,collate(0,127)||kcvt(collate(128,255),'latin1','utf-8'));
      if _n_ then _character_=tranwrd(_character_,ksubstr(_character_,_n_,1)
                  ,htmlencode(ksubstr(_character_,_n_,1),'7bit'))
      ;
    end;
  end;

topic import file -import wizard in SAS Programming

import file -import wizard

Re: import file -import wizard

Re: import file -import wizard

Re: import file -import wizard