特别鸣谢 sslovespain 的10/17/2016机经,和 helloalice110310/04/16 北美机经,几乎全中。有一些基础,SAS ADV前后准备不到一周,细细过了63题的知识点 + 米粮包的ADV最强机经,非常感谢前辈的整理!
sslovespain(10/17/2016) 原贴传送门:https://bbs.pinggu.org/thread-4885492-1-1.html
helloalice1103 (10/04/16) 原贴传送门:https://bbs.pinggu.org/thread-4863727-1-1.html
以下机经是基于两篇机经的原贴,整理得来。祝大家复习顺利,考试成功!
先说63题:
2
3
4
5
9 (变形,只有Jones 100,code里没有group by)
10 (变数字,11/5,答案选2。考点和24题一样,%eval function)
11 (答案:When the view TEMP is used in another SAS step, the data set is created.)
12
13 (变形,给出data set和output问code,merge和full join都在选项里,选择full join with coalesce)
14
15 (变形,数据变了,且有group by)
19
21
22 (答案不变,迷惑选项describe table=data set)
23
25 (变形,Belt=no,答案2)
27
30
31
32
37
38 (变形,答案0)
39 (变形,答案mv is bicycles)
40
41 (答案不变)
43 (变形,Jones 100, 答案having ave(Cost)<(Select avg...))
44
45 (变形,给出data set(其中一个没有sort)和output,和三个program,问哪个对,答案是proc SORT with nodupkey and output和proc sql with select distinct是可以的,data step with if first.customer_id不可以,因为有一个dataset没有sort)
47
48
49
51 (这里有人说是一道新题,但我觉得就是这个题的变体,给出题干一样的data set and work.temp is indexed(和原dataset一样,Id的顺序是PPAARRR,是没有sort过的). proc print data=work.temp; by Id; run; 问能不能执行?选项分别是
A. stops excute because dataset is not in ascending order.
B. stops excute because dataset is not in decending order
C. excute without problem and generate an output
D. excute only with index=USE option is on.
选择C)
54 (不变)
55 (变形,考了left join)
58
60 (变形,答案proc print only)
61
62 (选项变动为!!答案不变)
63 (经典变形,给出code,选variables)
填空 (米粮包-ADV最强机经):
1. %put _Global_
2. Average is ...__7__
3. outer union corr
4. COMPRESS=YES (忘记是不是选择题了)
5. Hash Alpha
其他:(大多数在米粮包-ADV最强机经里有)
2. cmplib变为选择题;
3. two years after this year is 2013+1+1
1;
4. keep=option in set statement;
5. array multi{1:2,2}(1,2); 答案
i j output
1 1 1
1 2 2
2 1 .
2 2 .; (选择题)
6. page side info哪个可以看,答案proc contents;
7. proc sort data= out= (drop=) nodupkey, by var; run;
8. proc means一个view 答案data=finance.newdata; (和用普通dataset一样);
9. call symputx('Num', California)迷惑选项没有call;
10. fmtsearch=(mylib,library);
11. sum(profit)=400;
12. idxname;
13. Two dataset用except,答案Charlie, Omar;
15. need 20% of observations. 答案Where;
16. which macro definition should be used.答案title %nrstr("");
17. Ask why program failed,答案order by statement cann't be used inside of an in-line view;