全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
4690 2
2014-07-11
Q34:
Given the variable attributes of SAS data sets ONE and  TWO:
         ONE                                        TWO
Variable Type Len                      Variable Type Len
sales      Num   8                       sales      Char  8
budget   Num   8                       year       Num  8
year       Num   8                     

Both data sets are sorted by the varialbe YEAR. The following SAS program is submitted:
data three;
merge one two;
by year;
run;

What is the result?
A. Data set THREE is created with two variables.
B. Data set THREE is created with three variables.
C. Data set THREE is createdand WARNING messages are written to the SAS log.
D. Data set THREE is not created. ERROR and WARNING messages are written to the SAS log.

答案给的是 D


Q85:
Given the SAS data set OURDATA:
Obs product sales
1 OR 1000
2 NE 1200
3 MM 1450
After submitting a SAS program, the following is written to the SAS log:
70 %macro a;
71 data _null_;
72 set ourdata;
73 call symput('product'!!left(_n_), product);
74 run;
75 %if &product1 = OR %then %do;
76 proc means data = ourdata;
77 run;
78 %end;
79 %mend;
80 %a
NOTE: Numeric values have been converted to character values at the places given by:
(Line):(Column). 73:66
NOTE: There were 3 observations read from the data set WORK.OURDATA.
NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand
is required. The condition was: &product1=OR
ERROR: The macro A will stop executing.
Which statement replaces the code in line 75 to successfully complete the program?
A.%if &product1 = %bquote(OR) %then %do;
B.%if %bquote(&product1) = OR %then %do;
C.%if %bquote(&product1 = OR) %then %do;
D.%if %bquote(&product1) = %bquote(OR) %then %do;

答案给的是D

Q99:
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

二套Q130 第8题:
The following SAS code is submitted:
%macro houses(dsn=houses, sub=RANCH);
data &dsn;
set sasuser.houses;
if style="&sub";
run;
%mend;
%houses(sub=SPLIT)
%houses(dsn=ranch)
%houses(sub=TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
答案给的是D

我感觉99题答案应该是Lirbarary.Formats 虽然没有这个选项。其余的都搞不懂。请教各位牛人啊!

二维码

扫码加我 拉你入群

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

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

全部回复
2014-7-22 17:00:09
Q34:
复制代码
复制代码


二维码

扫码加我 拉你入群

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

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

2014-7-28 09:04:26
920240553 发表于 2014-7-22 17:00
Q34:
多谢!
二维码

扫码加我 拉你入群

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

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

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群