请教几道SAS advanced题目

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

请教群里各位大神们几道advance题目，都是63题里面的：

Item 12.
Which title statement would always display the current date?

A. title "Today is: &sysdate.";
B. title "Today is: &sysdate9.";
C. title "Today is: &today.";
D. title "Today is: %sysfunc(today(),worddate.)";


用SAS试了一下至少A和B也是可以的啊，但是答案是D

Item 26
Given the following SAS data sets:
WORK.VISIT1 WORK.VISIT2
Id Expense       Id Cost
--- -------          --- ----
001 500         001 300
001 400         002 600
003 350

The following result set was summarized and consolidated using the SQL procedure:
Id Cost
--- ----
001 300
001 900
002 600
003 350
Which of the following SQL statements was most likely used to generate this result?

A.
select

Id,
sum(Expense) label='COST'
from WORK.VISIT1
group by 1
union all
select
Id,
sum(Cost)
from WORK.VISIT2
group by 1
order by 1,2
;

B.
select
id,
sum(expense) as COST
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost
;

C.
select
VISIT1.Id,
sum(Cost) as Cost
from
WORK.VISIT1(rename=(Expense=Cost)),
WORK.VISIT2
where VISIT1.Id=VISIT2.Id
group by Id
order by
Id,
Cost
;

D.
select
Id,

sum(Expense) as Cost
from WORK.VISIT1
group by Id
outer union corr
select
Id,
sum(Cost)
from WORK.VISIT2
group by Id
order by 1,2
;

为什么不是A呢？union all不可以吗？


Item  23
Item 23 of 63 Mark item for review
Given the SAS data set SASUSER.HIGHWAY:
Steering Seatbelt Speed Status Count
-------- -------- ----- ------- -----
absent No 0-29 serious 31
absent No 0-29 not 1419
absent No 30-49 serious 191
absent no 30-49 not 2004
absent no 50+ serious 216


The following SAS program is submitted:
%macro SPLIT;
proc sort
data=SASUSER.HIGHWAY
out=WORK.UNIQUES(keep=Status)
nodupkey;
by Status;
run;


data _null_;
set uniques end=Lastobs;
call symputx('Status'||left(_n_),Status);
if Lastobs then call symputx('Count',_n_);
run;


%local i;
data
%do i=1 %to &count;
[_insert_reference_]
%end;
;

set SASUSER.HIGHWAY;
select(Status);
%do i=1 %to &Count;
when("[_insert_reference_]") output [_insert_reference_];
%end;
otherwise;
end;
run;
%mend;

%SPLIT

What macro variable reference completes the program to create the WORK.NOT and WORK.SERIOUS data sets?

A. &Status&i
B. &&Status&i
C. &Status&Count
D. &&Status&Count


完全没有get到这道题的point啊TT，大神们可否给讲一下程序要干啥~



Item 43
Given the SAS data set WORK.ONE:
Rep Cost
----- ----
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100


The following SAS program is submitted:
proc sql;
select
Rep,
avg(Cost) as Average
from WORK.ONE
[either__insert_SQL_where_clause_]
group by Rep
[_or_ _insert_SQL_having_clause_]
;
quit;


The following output is desired:
Rep Average
----- -------
SMITH 400


Which SQL clause completes the program and generates the desired output?
A. where calculated Average > (select avg(Cost) from WORK.ONE)
B.having Average > (select avg(Cost) from WORK.ONE)
C. having avg(Cost) < (select avg(Cost) from WORK.ONE)
D. where avg(Cost) > (select avg(Cost) from WORK.ONE)



答案是B，为啥A不可以呢？用了calculated呢~

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Advanced ADVANCE advan VANCE ance following current display always title

自己顶。。。

Item 12：sysdate是系统日期，today（）才是当前日期。
Item 26：这个题是选A啊。
Item 23：

1. /*Item 23 of 63 Mark item for review
   
2. Given the SAS data set SASUSER.HIGHWAY:
   
3. Steering Seatbelt Speed Status Count
   
4. -------- -------- ----- ------- -----
   
5. absent No 0-29 serious 31
   
6. absent No 0-29 not 1419
   
7. absent No 30-49 serious 191
   
8. absent no 30-49 not 2004
   
9. absent no 50+ serious 216
   
10. The following SAS program is submitted:
    
11. */
    
12. %macro SPLIT;
    
13. proc sort
    
14. data=SASUSER.HIGHWAY
    
15. out=WORK.UNIQUES(keep=Status)
    
16. nodupkey;
    
17. by Status;
    
18. run;
    
19. /*上面程序是对数据集进行排序*/
    
20. 
    
21. data _null_;
    
22. set uniques end=Lastobs;
    
23. call symputx('Status'||left(_n_),Status);
    
24. if Lastobs then call symputx('Count',_n_);
    
25. run;
    
26. /*这个是利用call symputx（）函数创建宏变量status1，status2，……，直到数据最后一个，每一个宏变量的值对应每一个观测，lastobs代表最后一个观测，此时创建宏变量count，它的值为数据集中观测的个数N*/
    
27. 
    
28. %local i;
    
29. data
    
30. %do i=1 %to &count;
    
31. [_insert_reference_]/*答案应该是B*/
    
32. %end;
    
33. ;
    
34. /*上面实际是一个data status1 status2 status3 …………直到status（&count），利用（%do-%end;)循环来达到这个目的*/
    
35. set SASUSER.HIGHWAY;
    
36. select(Status);
    
37. %do i=1 %to &Count;
    
38. when("[_insert_reference_]") output [_insert_reference_];
    
39. %end;
    
40. otherwise;
    
41. end;
    
42. run;
    
43. %mend;
    
44. 
    
45. %SPLIT
    
46. 
    
47. /*What macro variable reference completes the program to create the WORK.NOT and WORK.SERIOUS data sets?
    
48. 
    
49. A. &Status&i
    
50. B. &&Status&i
    
51. C. &Status&Count
    
52. D. &&Status&Count
    
53. */

复制代码

Ttem 43：在对group里的变量进行条件设置的时候需要用having，where是针对所有观测的。

mingfeng07 发表于 2014-6-5 12:41
Item 12：sysdate是系统日期，today（）才是当前日期。
Item 26：这个题是选A啊。
Item 23：

太感谢了！受益匪浅！！

mingfeng07 发表于 2014-6-5 12:41
Item 12：sysdate是系统日期，today（）才是当前日期。
Item 26：这个题是选A啊。
Item 23：

再请教一道：
65. The following SAS program is submitted:
proc append data = M base = F; run;
Which SQL procedure program will produce the same results?
A.proc sql;
insert into F select * from M;
quit;

B.proc sql;
select * from F
outer union corr
select * from M;
quit;

C.proc sql;
create table F as
select * from F intersect
select * from M;
quit;

D.proc sql;
create table F as
select * from F intersect corr
select * from M;
quit;

为什么选A而不是B？outer union不是就是concatenate吗？

龙在云霄柳在岸 发表于 2014-6-6 09:38
再请教一道：
65. The following SAS program is submitted:
proc append data = M base = F; run;

B选项只是把结果呈现出来，并没有创建表格。

mingfeng07 发表于 2014-6-6 10:24
B选项只是把结果呈现出来，并没有创建表格。

原来如此！懂了非常感谢！！

mingfeng07 发表于 2014-6-6 10:24
B选项只是把结果呈现出来，并没有创建表格。

再请教一道题：
Given the following OPTIONS statement:
Libname A 'SAS library reference';
libname F 'SAS library reference';
options fmtsearch=(A F.X);

What is the second location searched for formats?

A. F.X
B. A.FORMATS
C. WORK.FORMATS
D. SAS supplied formats

答案给的是C，但我觉得应该是B吧， work的不是第一个search吗~然后是library.formats

龙在云霄柳在岸 发表于 2014-6-7 12:06
再请教一道题：
Given the following OPTIONS statement:
Libname A 'SAS library reference';

嗯，你想的是对的。

mingfeng07 发表于 2014-6-7 22:57
嗯，你想的是对的。

好的谢谢啊！！