Free SASInstitute A00-211 Practice Test & Real Exam Questions
The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?
Correct Answer: C
Vote an answer
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
The following program is submitted:
Which output is correct?
Correct Answer: A
Vote an answer
Which one of the following is true of the RETAIN statement in a SAS DATA step program?
Correct Answer: D
Vote an answer
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
What does it mean?
Correct Answer: B
Vote an answer
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
Correct Answer: A
Vote an answer
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?
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?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
What new value would be assigned to X if its original value was a missing value?
What new value would be assigned to X if its original value was a missing value?
Correct Answer: A
Vote an answer
The following SAS program is submitted:
data one;
addressl = '214 London Way';
run;
data one;
set one;
address = tranwrd(address1, 'Way', 'Drive'); run;
What are the length and value of the variable ADDRESS?
data one;
addressl = '214 London Way';
run;
data one;
set one;
address = tranwrd(address1, 'Way', 'Drive'); run;
What are the length and value of the variable ADDRESS?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?
Correct Answer: B
Vote an answer
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;
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;
Correct Answer: C
Vote an answer
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price". Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
Correct Answer: C
Vote an answer
