Help using Base SAS procedures

UTF8 compliant import

Reply
Contributor
Posts: 28

UTF8 compliant import

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;

Valued Guide
Posts: 3,208

Re: UTF8 compliant import

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#n0882t2muy4l94n19cn...http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cn...

---->-- ja karman --<-----
Contributor
Posts: 28

Re: UTF8 compliant import

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";

Respected Advisor
Posts: 3,887

Re: UTF8 compliant import

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.

Ask a Question
Discussion stats
  • 3 replies
  • 226 views
  • 0 likes
  • 3 in conversation