Only standard SQL are the same for different software. And each software adds more functions to its own version.

USE 'translate' or 'tranwrd' functions instead of replace in SAS.

我是这样干的

data air;
infile 'd:\sj\air.txt';
input Empid JobCode $ Salary $ 8. Bonus ;
proc sql;
select substr(JobCode,1,2)  /*(变量，从第一个字符截取，2个宽度)*/
label='wxq1638',
count(*) as count /*将条件数据赋予表count*/
from air  /*读入数据*/
group by 1;