topic Re: UTF8 compliant import in SAS Procedures

UTF8 compliant import

Mikeyjh — Tue, 10 Sep 2013 17:02:02 GMT

Hi,

Could you please convert the following import statement to a UTF8 compliant version? (The input text file is UTF8 and the dataset needs to be UTF8 compliant.) Thanks for your help.

data dir.ds;

%let _efierr_ = 0;

infile "&in\ds.txt" delimiter = ',' missover dsd firstobs = 2;

format colA $10. ;

format colB $10. ;

format colC $10. ;

...

informat colA $10. ;

informat colB $10. ;

informat colC $10. ;

...

input

colA $

colB $

colC $

...;

if _error_ then call symput('_efierr_',1);

run;

Re: UTF8 compliant import

jakarman — Tue, 10 Sep 2013 19:10:51 GMT

If your SAS installation is UTF compliant (DBCS) and your encoding is UTF in SAS what is this question about?

http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm

Re: UTF8 compliant import

Mikeyjh — Tue, 10 Sep 2013 21:49:20 GMT

Thanks for your reply. Yes the installation is UTF8 compliant.

Do I need to use the following to be able to read from a UTF8 text file and retain compliance in the dataset? We are using 9.1.3.

libname mylib outencoding="utf-8";

infile myfile encoding="utf-8";

Re: UTF8 compliant import

Patrick — Tue, 10 Sep 2013 22:46:26 GMT

It's for sure a good idea to specify the encoding explicitly. Some UTF8 encoded files don't have a BOM so telling SAS which encoding to use will help avoiding issues.