总共考了60题,基本全在63题和之前的机经当中,大家去看之前的总结就行,我主要参考的是这个贴
https://www.1point3acres.com/bbs/thread-313614-1-1.html
还有我看到很少有人提及SAS官网提供的sample questions,那个要看的,只有9道题,会考到原题。我贴到后面了,大家可以看看。
新题有3道,原句记得不是特别清了,就大概描述下。
1. what kinds indexes only can be created by proc datasets
A. multiple variables
B. including missing value
C. 不记得了,也是个常见的index
D. 不记得了,但是没见过
通过排除法选D
2. large dataset using where, what is the best indexes
A. the index includes as many as possible observations
B. the index disqualified as many as possible observations
C. include numaric variables
D. composite index
应该选B, 我已开始选对结果改错导致最后错一道
3. 是sample question里面question 5 的变形,问的是select tables with columns name ended “Date” in the library "ORION".
四个选项跟question 5差不多,选那个含“from dictionary.column”的选项
另外question 5原题也考到了。
还有一道题之前的机经里面出现过,可能之前的大大们code记得不太清,我当时run sas就出不来结果。大大们提供的选项是对的,这次考到我特地记了一下code
就是这道
Product
Product_id Product
1 1001
2 1002
3 1003
Sales
Product_id Sales
3 100
1 200
5 100
1 200
3 100
1 100
给的code是这样的
Proc sql;
Select p.product, s.totalsales
From product as p
left join (
select sum(sales) as totalsales
from sales
group by product_id as s)
on p.product_id=s.product_id;
quit;
答案没变,还是之前机经给出的
Product Totalsales
1001 500
1002 .
1003 200
好了,我现在开始准备clinical trial的考试了,考完了再来分享机经。