당신은 온라인 연습 문제를 통해 SAS Institute A00-211 시험지식에 대해 자신이 어떻게 알고 있는지 파악한 후 시험 참가 신청 여부를 결정할 수 있다.
시험을 100% 합격하고 시험 준비 시간을 35% 절약하기를 바라며 A00-211 덤프 (최신 실제 시험 문제)를 사용 선택하여 현재 최신 262개의 시험 문제와 답을 포함하십시오.
/ 6
Question No : 1
Which statement is true concerning the SAS automatic variable _ERROR_?
정답:
Question No : 2
The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?
정답:
Question No : 3
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile ‘amount’;
input@1 salary 6.;
if_error_then description = ‘Problems’;
else description = ‘No Problems’;
run;
What is the result?
정답:
Question No : 4
The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
정답:
Question No : 5
The following output is created by the FREQUENCY procedure:
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;
정답:
Question No : 6
The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
정답:
Question No : 7
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
정답:
Question No : 8
The following SAS program is submitted:
data one;
date = ‘04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?
정답:
Question No : 9
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = ‘Jan’ then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
정답:
Question No : 10
The following SAS program is submitted:
data work.flights;
destination = ‘cph’;
select(destination);
when(’LHR’) city = ‘London’;
when(’CPH’) city = ‘Copenhagen’;
otherwise city = ‘Other’;
end;
run;
What is the value of the CITY variable?
정답:
Question No : 11
The following SAS program is submitted:
data WORK.ONE;
Text=’Australia, US, Denmark’;
Pos=find (Text,’US’,’i’,5);
run;
What value will SAS assign to Pos?
정답:
Question No : 12
The following SAS program is submitted:
The program fails execution due to syntax errors.
What is the cause of the syntax error?
정답:
Question No : 13
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
정답:
Question No : 14
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
정답:
Question No : 15
Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
