a. The automatic variables _N_ and _ERROR_ are incremented by one. b. The DATA step stops execution. c. The descriptor portion of the data set is written .(compilation phase) d. The values of variables created in programming statements are re-set to missing in the program data vector. Answer: By default, at the end of the DATA step, the values in the program data vector are written to the data set as an observation , the value of the automatic variable _N_ is incremented by one, control returns to the top of the DATA step, and the values of variables created in programming statements are set to missing. The automatic variable _ERROR_ retains its value.
用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;