Our SAS Institute A00-211 practice questions along with answers are created in higher standards regarding technical accuracy. Actualtests provides you with A00-211 exam questions together with verified and corrected answers which reflect the SAS Institute A00-211 exam syllabus. Our own chief purpose: spend a lesser number of money and get more valuable SAS Institute SAS Institute certification study components for our customers. Looking at with other vendor in the market, youll find our value is reasonable and items helpful. Obtain certified and download SAS Institute A00-211 braindumps to your computer appropriate now! We keep presenting free updated SAS Institute study components since your date of buy. Our team can be at your command if you encounter some difficulties. Preserve visiting our site so that you can preserve abreast of the availability in the SAS Institute A00-211 updates.
2021 Oct A00-211 exam price
Q91. 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?
A. ods html open='sales.html' ods html close;
B. ods file='sales.html' / html; ods file close;
C. ods html file='sales.html' ods html close;
D. ods file html='sales.html' ods file close;
Answer: C
Q92. The following SAS program is submitted;
data combine;
country = ‘Italy, Russia, ireland’;
found = find(country, ‘i’);
run;
What is the value of the variable FOUND in the output data set?
A. 1
B. 12
C. Italy
D. Russia
Answer: B
Q93. You're attempting to read a raw data file and you see the following messages displayed in the SAS Log: What does it mean?
A. A compiler error, triggered by an invalid character for the variable Salary.
B. An execution error, triggered by an invalid character for the variable Salary.
C. The 1st of potentially many errors, this one occurring on the 4th observation.
D. An error on the INPUT statement specification for reading the variable Salary.
Answer: B
Q94. Which program displays a listing of all data sets in the SASUSER library?
A. proc contents lib = sasuser.all; run;
B. proc contents data = sasuser.all; run;
C. proc contents lib = sasuser._alI_; run;
D. proc contents data = sasuser._all_; run;
Answer: D
Q95. 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;
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?
A. keep product sales;
B. keep product, sales;
C. keep = product, sales;
D. keep = (product sales);
Answer: A
Leading A00-211 practice test:
Q96. The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
A. 0
B. 1
C. 5
D. 60
Answer: B
Q97. The following SAS program is submitted:
libname company 'SAS-data-library' proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?
A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
Answer: A
Q98. The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
A. The program fails execution due to data errors.
B. The program fails execution due to syntax errors.
C. The program executes with warnings and creates the WORK.TOTALSALES data set.
D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
Answer: B
Q99. The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:
WORK.ONE Num Char
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num='1'
run;
What is output?
A. Num Char 1 23
B. Num Char 1 23 1 77
C. Num Char 1 23 3 23 1 77
D. No output is generated.
Answer: D
Q100. The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen'
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:
A. var Height / nobs min max mean maxdec=1;
B. proc means data=SASHELP.CLASS maxdec=1 ;
C. proc means data=SASHELP.CLASS min max mean maxdec=1;
D. output nobs min max mean maxdec=1;
Answer: C