人大经济论坛 › 标签 › Set › 相关日志

标签: Set经管大学堂：名校名师名课

相关日志

分享 End of Data step 6.6 of 220: yukai08008 2013-3-16 17:11; 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.; 个人分类: 学习笔记|0 个评论

分享 69 of 70 用like寻找匹配词: yukai08008 2013-3-13 23:37; 用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;; 个人分类: 学习笔记|1 次阅读|0 个评论

联系客服

邮箱：service@pinggu.org 投诉或不良信息处理：（010-68466864）