SAS_ADV_2014.11.02新题

1.自定义函数

具体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，其他选项记不清了

2.%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

3.

4. 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. 不记得了，是个不相关的选项

我也没搞清楚，IF-THEN/ELSE和WHERE的efficiency比较

5. 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，不知道对不对

6. 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 .

7. SAS log 显示三个global macro variables，问如何在log中输出global macro variables，

答案：%put _GLOBAL_; 填空，填_GLOBAL_

8. 问哪个命令可以看page size

A. PRINT procedure

B. CONTENTS procedure

C. REPORT procedure

D. CATALOG procedure

答案为CONTENTS procedure

9. Given the SAS data set one:

Rep Cost

SMITH 20

SMITH 40

JONES 10

SMITH 60

JONES 10

Which SAS program can generate the following result?

Rep

JONES 20

JONES 20

SMITH 120

SMITH 120

SMITH 120

答案：

Proc sql;

Select rep,

Sum(Cost)

From one

Group by Rep;

Quit;

10. SQL中except corr用法，给定data set和program，问output，具体记不清了

11. 具体的data set和program不记得了，以下内容仅供参考，主要就是data中有个missing

value，算均值

Given the SAS data set ONE

ONE

Rep Cost

SMITH 200

JONES 100

JONES 100

SMITH 600

CHANG 400

JONES .

CHANG 600

The following SAS program is submitted:

Proc sql;

Select rep,

Avg(Cost) as Average

From ONE

Group by rep

Having Average ge 100;

Quit;

问output，按照上面举例的data set和program，output应该是：

Rep Average

------------------

CHANG 500

JONES 100

SMITH 400

12. 给一个SQL statement，

Select Jobcode, Salary,

(select avg(Salary)

From WORK.PILOTS

Order by Jobcode) as Avg

From WORK.PILOTS

Order by ID;

问为什么运行失败，

答案：You cannot use an ORDER BY clause in an in-line view

13. 给定一个data set和SQL代码，问输出结果一致的是：

具体不记得了，摘一段类似的，考点在nodupkey，注意要drop掉一个variable

proc sort data=retail.order_fact

out=work.sorted (drop=XXX) nodupkey;

by order_date;

run;

14. 填空，补全代码以选出unique value of a grouped variable

If______=1 then output=XXX 的句式

答案：first.variable (变量名不记得了)

15. data company.newdata / view=company.newdata;

infile ;

run;

以上代码create a data step view之后，要在proc means中使用view，问应该用哪个代码：

A．proc means view= company.newdata;

B．proc means data=company.newdata / view=company.newdata;

C．proc means data company.newdata / view

D．不记得了

具体代码是记不清了，大概就是以上的形式，答案我也不晓得= =

16. call symputx('macro-variable'||left(_n_),expression);的用法

题目给出一个program，并给出条件，要求补全代码，应该选以上格式的那个选项

还有个别新题实在是回忆不起来了，不过有这么多已经比较齐全了。

下面写写今天碰到的63题中的原题和变题：

2

3

4

5

9 output变为JONES 105，选答案中没有group by Rep的那一项

10 %let value=1；所以答案为2

11 data set名称有变化，答案没变

12

13

19

21

22

23

25 代码中No和no换了下，答案为2

27

30

31

32

37

38 %check=(Num=10)变成了%check=(Num=4)，答案为0

39 bicycles和shoes位置换了，为Mv is bicycles

40

41

43 output变成JONES 100，

所以答案选having avg(Cost)<(select avg(Cost)from WORK.ONE)

45 题干换成了code形式，不过交代了unsorted，所以答案还是一样的

47

48

49

51 给全了代码，题目里by ID；填进去了，问运行结果，答案选能够运行without errors

54

55 output变成了

Year Qtr Sales Budget

2001 4 300 500

2001 4 300 400

. . . 350

所以答案为left join

58

60 mean和print位置换过了，所以答案为PROC PRINT only

61

62

63 语句已经给出了，问输出的四个变量时什么，答案为weight，height，name，age

能记起来的就这么些了，可能有些题有些细微的变化，我也没注意，反正63题上的理解了之后做起来没问题的……

关于proc sql的table combination考得太多了，题目实在是记不清了，

考到的有以下set operator和keyword：

Except

Except all

Except corr

Intersect corr

Outer union corr

Union corr