用like的缺点是 按字精确匹配 scan则是要清楚所选词出现的具体位置 proc import dbms=excel out=ser datafile='F:\raw material\_69 of 70.xls' replace; run; data res; set ser; where job like '%manager%';/*严格按字匹配*/ run; data res2; set ser; where upcase(scan(job,2))='MANAGER';/*需要制定具体的位置,如第二个词*/ run; data res3; set ser; if upcase(substr(job,)) proc print data=res2; run;
“I started from this damn recession and what it meant to so many people who lost their job. There are many extremely talented dancers kicked out or chefs left without a job, those who pass by us on the street and whose incredible ability to dance or to prepare exceptional dishes remain the same, at any time. Dance always accompanies a dancer, whether he is paid for what he does, or not” said Jordan Matter.