刚刚考完,趁还热乎赶紧写,不过也没几个记得的了。。。
个人情况:完全0基础,base已经是一年多前水过的了,计划是两个星期过ADV,第一个星期看GUIDE,除了基础的内容以外没什么能记住的,东西实在太多,尤其如果不上手的话,很悲剧。第二个星期看米粮包和JJ总结,救命神器。。。
确实改了部分题库,有35-40道是JJ原题或者变体,有的变得太厉害,我都不太确定是不是原题了。。。
left join, right join, full join 什么的拜托大家搞清楚!!我被考了起码5道,不理解只背答案,一改题干的话就是大写的杯具啊!!!
一道新题,抱歉学艺不精只能记个大意了,如果有大神见到过或者会做,欢迎留言,我会更新到帖子中:
When would it be most efficient to use multiple SET statements in the DATA Step?
A. One file has large amount of rows of data, another one only has small number of data
Index is used as key (这句表述我不太确定)
B. Both files have large amount of rows of data
Index is used as key
C. One file has large amount of rows of data, another one only has small number of data
Index is NOT used as key
D. Both files have large amount of rows of data
Index is NOT used as key
然后把遇到的题+变体+变变体情况总结在文档中了。 两个版本,word方便大家再编辑,如果只是看,下一个就够了。
收个辛苦费,攒够了币接着考SBA ~~~~
谢谢!!!加油!!!