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;
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...
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";
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.