sas - 如何删除特殊 ASCII 字符？

Question

我正在尝试从字符串中删除特殊字符。

“孟买降雨实时更新:IMD 预测 future 24 小时将有强降雨 �”

data demo1 (keep=headline2 headline3 headline4 headline5);
set kk.newspaper_append_freq_daily1;
headline2=trim(headline);
headline3=tranwrd(headline2,"�"," ");
headline5=compress(headline2,"�");
headline4=index(headline2,"�");
run;

Answer 1

您可以使用kpropdata功能。来自文档:

Removes or converts unprintable characters.

代码示例:

%let in=kk.newspaper_append_freq_daily1;
%let out=demo1;

data &out; 
set ∈ 
array cc (*) _character_; 
do i=1 to dim(cc); 
 cc(_N_)=kpropdata(cc(i),"TRUNC", 'utf-8'); 
 end; 
run; 

在我使用的代码中 array语句迭代表中的所有字符列。