发帖
雷达卡
学习资料：SAS online tutor, 网址http://web.utk.edu/sas/OnlineTutor/1.2/en/60477/index.htm，国内童鞋不知道是否需要翻墙。网站做的非常棒，很系统，也有练习题，要真的学的扎实的，建议还是都尽量跑一遍，加深映象，而且也会提高学习SAS的兴趣，玩到后面停不下来啊
考题复习资料：50+63足矣，加上论坛的机经，我主要看得
[学习分享] SAS BASE/Advanced 2015 9月 考试心得和最全机经https://bbs.pinggu.org/thread-3917242-1-1.html
需要20个论坛币，但是确实资料全
63里有的问题有点乱，建议大家都跑一遍，有的答案被论坛上有的人搞错误了，晕死，如果有crackman解释的建议一crackman为依据，其他的最好能找到原文
考的63原题有
| NO | Yes/No/Change Question | Changed Question | Comments |
1 | Y | ||
2 | Y | ||
3 | Y | ||
4 | Y | 问题用的表有很多次，因此请一定仔细读题，并吃透考的内容 | |
5 | Y | ||
6 | N | ||
7 | N | 这道题依据找到的文字资料，答案确实应该是two times，请注意four times是entirely run, not required to run | |
8 | N | ||
9 | Y | ||
10 | Change | %let value=11, answer=2 | |
| 11 | y | ||
12 | y | ||
13 | y | ||
14 | y | be careful there is space not "=" | |
15 | y | ||
16 | y | ||
17 | n | ||
18 | N | ||
19 | Y | ||
20 | N | ||
21 | Y | ||
22 | Y | ||
23 | Y | ||
24 | Y | ||
25 | CHANGE | change %Highway(Belt=no), answer=2 | |
| 26 | n | ||
27 | y | ||
28 | y | ||
29 | y | ||
30 | y | ||
31 | y | ||
32 | y | ||
33 | y | ||
34 | y | ||
35 | n | ||
36 | n | ||
37 | y | ||
38 | change | %check(Num=4), answer=0 | |
| 39 | change | %let Mv=bicycles, answer=bicycles | |
| 40 | y | ||
41 | y | ||
42 | n | ||
43 | change | having avg(cost)<(select avt(cost) from work.one) | |
| 44 | y | ||
45 | Change | give the code and change the sequence, select the technique use sort NODUPKEY and Select Distinct | |
| 46 | y | ||
47 | y | ||
48 | change | give another date, but answer is the similar with "&XXX"d | |
| 49 | y | ||
50 | n | ||
51 | y | ||
52 | n | ||
53 | n | ||
54 | y | ||
55 | n | ||
56 | n | ||
57 | n | ||
58 | y | ||
59 | n | ||
60 | change | change print with mean, so answer: only proc print | |
| 61 | y | ||
62 | y | ||
63 | change | answer Height Weight Name Age |
机经有：
1.
题目给出dataset和macro program，要求补全代码
选项有 &Num=California, call symputx('&Num', California) 等
答案是call symputx('&Num', California)
2. 填空题。填corr，考Append等价于 out union corr
3. 填空题，关于hash，填hashalpha
4. 填空题。给出数据组和代码，从subquery返回Name的两个值，据此得出avg(Num)的结果。答案是7,
5. 你需要重复用到同一个local data set, 用SASFILE会对Global statement什么的有什么影响，答案选increase memory
6. 说如果要用specific index，用啥，选IDXNAME
7. proc sql;
create table forecast as
select a.*, b.sales
from actual a,_______
where a.dept=b.dept
在空缺处填入代码。答案是：
(select
avg(revenue) as average
from Budegt
group by 1) b
有干扰项：
select (
avg(revenue) as average
from Budegt
group by 1) b
8.
具体code不记得了，从网上摘抄一段供参考：
proc fcmp outlib=sasuser.funcs.trial;
function study_day(intervention_date, event_date);
if event_date < intervention_date then
return(event_date – intervention_date);
else
return(event_date – intervention_date + 1);
endsub;
options ________=sasuser.funcs;
data _null_;
start = '15Feb2006'd;
today = '27Mar2006'd;
sd = study_day(start, today);
put sd=;
run;
补全代码
答案：选cmplib
9. %let this_year=%substr(&sysdate9,6);
%let next_year=&this_year+1;
%let check_year=%eval(&next_year<2016);
%put two years after this year is &next_year+1;
%put &check_year;
假设系统时间为01JAN2013，问输出内容
答案：
two years after this year is 2013+1+1
1
10. A data set has 2000million observations and 300 character variables 问compress方法答案：compress=YES
11. A data set has 200,000 observations, 300 variables, compressed
If you need 20% of character observations, what method can minimize computer resource usage?
A. IF-THEN/ELSE B. CASE C. WHERE D. 不记得了，是个不相关的选项
选where
11. A data set has 300,000 observations, 20 character variables, 50 numeric variables, 我们需要其中的5 character variables和7 numeric variables，which is most efficient：
A. DROP= option in data step
B. KEEP= option in data step
C. KEEP= option in set statement
D. KEEP statement
我选的KEEP= option in set statement
12. Array multi{1:2,2} (1,2);
Do i=1 to 2;
Do j=1 to 2;
Output =multi{i.j};
问i，j和对应output的值，答案：
i j output
1 1 1
1 2 2
2 1 .
2 2 .
13. SAS log 显示三个global macro variables，问如何在log中输出global macro variables，答案：%put _GLOBAL_; 填空，填_GLOBAL_
14. 给定一个data set和SQL代码，问输出结果一致的是： 具体不记得了，摘一段类似的，考点在nodupkey，注意要drop掉一个variable
proc sort data=retail.order_fact
out=work.sorted
(drop=XXX)
nodupkey;
by order_date;
run;
15. 答案是选 Charlie
Osmer
16. 想要输出 title “XXXXX A&M XXXXXX”; 要定义macro variable来实现
选项里面有 %sysfunc(title())
%str(title “XXXXX A&M XXXXXX”;)
%nrstr();
%bquote();
答案选%nrstr()
其实考试时间不用太长，很多题题干完全没用，先看问题，如果和题干无关就没必要看题干了，节省时间
祝大家一切顺利
最后分享一个本人的学习笔记，advance内容超级多，笔记都有不少，上传两个版本，一个pdf一个onenotes，有安装onenotes的建议用onenotes看，章节清晰
advance notes.zip
(3.44 MB, 需要: 3 个论坛币)
本附件包括：- SAS Advance Learning.onepkg
- SAS Advance Learning-Notes.pdf
京公网安备 11010802022788号
