发帖
雷达卡
先说63题：
2
3
4
5
9 (变形，没有group by)
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 (变形，数据变了，且有grouo by)
16 (考的是intersect的output)
19
21
22 (答案不变，迷惑选项describe table=data set)
23
25 (变形，Belt=no，答案2)
27
30
31
32
37 (变形，code里面是except all, 给出四个output选哪个，答案就是原题目的题干)
38 (变形，check(Num=4)，答案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.证明是对的.之前看到的机经没有答对的，希望大家注意！)
52
54 (变形，选项变了我以为是没见过的题，Name1=MATH1, Name2=MATH3，答案是MATH3)
55 (考了left join)
58
59 (变形，答案proc print only)
61
62 (选项变动为！！答案不变)
63 (经典变形)
填空：
1. %put _Global_
2. if first.model=1
3. outer union corr
4. COMPRESS=YES
5. where s.state="&selection"(s忽略大小写)
其他：
1. average 7 变为选择题;
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. pagesige 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;
14. Two dataset用left join还是right join忘了，答案选择Thomas, Smith, Jones,没有Adam的那一项，并且sales要descending;
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;
特别感谢https://bbs.pinggu.org/thread-3839122-1-1.html的最强机经，以及大名鼎鼎的米粮包https://bbs.pinggu.org/thread-4172814-1-1.html。
最后祝各位考试顺利！
京公网安备 11010802022788号
