Can SAS 9.1.3 read csv file with utf8 BOM?

Question

I am using SAS 9.1.3 in AIX 5.3

I have to proc import a CSV file using SAS.
The first line of CSV are column names.
SAS reports error in the log.

Then, I find out that the CSV file has 3 characters
(which is the utf8 byte order mark).
at the very beginning of the file.

I tried to use :

filename XXX 'XXXXXXXXXX' BOM ;

But, this is syntax error.

I replace BOM with BOMFILE, still syntax error.

It seems that SAS 9.1.3 cannot recognize the BOM options.

Does anyone have similar experience ?

Try runsubmit.com - it's like StackOverflow but just for SAS. — Robert Penridge

rwill rwill · Accepted Answer · 2011-03-04T21:56:38

Instead of the import procedure, you might try a data step like the following:

data test;
  infile "data.csv" firstobs=2 dlm=',';   /* assuming delimiter is a comma */
  input                                   /* use Input with $UTF8Xw. informat */
     field1 $utf8x3.                      /* input fields 1 through 3  */
     field2 $utf8x10.
     field3 $utf8x3.
  ;
  run;

Can SAS 9.1.3 read csv file with utf8 BOM?

2 Answers