SAS ADV 考试 Q130 34，85， 99题 二套Q130 8题 求解

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

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 虽然没有这个选项。其余的都搞不懂。请教各位牛人啊！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：observations Successfully observation successful Attributes following created result

Q34：

1. data one;
   
2. input sales  budget  year ;
   
3. cards;
   
4. 500        499        2014
   
5. ;
   
6. data two;
   
7. /*infile datalines pad;*/
   
8. input sales :$8. budget :$8. year :$8. ;
   
9. cards;
   
10. 501 498 2013
    
11. ;
    
12. run;
    
13. proc sort data = one;
    
14. by year;
    
15. run;
    
16. proc sort data = two;
    
17. by year;
    
18. run;
    
19. data three;
    
20. merge one two;
    
21. by year;
    
22. run;

复制代码

1. 301  data three;
   
2. 302  merge one two;
   
3. ERROR: 变量 sales 已定义为字符型和数值型。
   
4. ERROR: 变量 budget 已定义为字符型和数值型。
   
5. ERROR: 变量 year 已定义为字符型和数值型。
   
6. 303  by year;
   
7. 304  run;
   
8. 
   
9. NOTE: SAS 系统由于错误而停止了该步的处理。
   
10. WARNING: 数据集 WORK.THREE 可能不完整。该步停止时，共有 0 个观测和 3 个变量。
    
11. WARNING: 数据集 WORK.THREE 由于该步已停止，而没有被替换。
    
12. NOTE: “DATA 语句”所用时间（总处理时间）:
    
13.       实际时间         0.01 秒
    
14.       CPU 时间         0.01 秒

复制代码

920240553 发表于 2014-7-22 17:00
Q34：

多谢！