A00-211 Premium Files Updated Oct-2022 Practice Valid Exam Dumps Question
Practice with A00-211 Dumps for SAS Institute Systems Certification Certified Exam Questions & Answer
NEW QUESTION 165
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION 166
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
- A. Option A
- B. Option C
- C. Option B
- D. Option D
Answer: C
Explanation:
Section: Volume A
NEW QUESTION 167
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?
- A. ''(missing character value)
- B. Copenh
- C. Other
- D. Copenhagen
Answer: C
Explanation:
Section: Volume A
NEW QUESTION 168
The following SAS program is submitted:
What new variables are created?
- A. Janpt, Febpt, and Marpt
- B. Difcount1, Difcount2 and Difcount3
- C. Diff1, Diff2 and Diff3
- D. Patients1, Patients2 and Patients3
Answer: B
NEW QUESTION 169
Which statement is true concerning the SAS automatic variable _ERROR_?
- A. It cannot be used in an if/then condition.
- B. It is automatically dropped.
- C. It can be put into a keep statement or keep= option.
- D. It cannot be used in an assignment statement.
Answer: B
NEW QUESTION 170
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
- A. do i = 1 to 5;
- B. A DO loop cannot be used because the variables referenced do not end in a digit.
- C. do weekly{i} = 1 to 5;
- D. do i = mon tue wed thu fri;
Answer: A
Explanation:
Section: Volume B
NEW QUESTION 171
A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations does the WORK.CONDO_RANCH data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 172
This question will ask you to provide lines of missing code.
The following SAS program is submitted:
Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?
A:
B:
C:
D:
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: D
NEW QUESTION 173
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
- A. libname sasdata 'SAS-data-library';
data sasdata.mydata;
save mydata;
run; - B. libname sasdata 'SAS-data-library';
data sasdata.mydata;
copy mydata;
run; - C. libname sasdata 'SAS-data-library';
data sasdata.mydata;
keep mydata;
run; - D. libname sasdata 'SAS-data-library';
data sasdata.mydata;
set mydata;
run;
Answer: D
NEW QUESTION 174
Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO:
The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
- A. Option C
- B. Option A
- C. Option D
- D. Option B
Answer: A
NEW QUESTION 175
The contents of the raw data file NAMENUM are listed below:
--------10-------20-------30
Joe xx
The following SAS program is submitted:
data test;
infile 'namenum';
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?
- A. Joe
- B. xx
- C. The value can not be determined as the program fails to execute due to errors.
- D. . (missing numeric value)
Answer: D
Explanation:
Section: Volume B
NEW QUESTION 176
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then'
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?
- A. (missing numeric value)
- B. 0
- C. 1
- D. 2
Answer: D
NEW QUESTION 177
What describes the SAS automatic _ERROR_ variable?
- A. The _ERROR_ variable contains the values 'TRUE' or 'FALSE.'
- B. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
- C. The _ERROR variable maintains a count of the number of data errors.
- D. The ERROR_variable contains the number or the observation that caused the error.
Answer: B
NEW QUESTION 178
The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?
- A. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
- B. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
- C. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
- D. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
Answer: A
NEW QUESTION 179
A raw data file is listed below:
--------10-------20-------30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37
The following SAS program is submitted using the raw data file as input:
data work.homework;
infile 'file-specification';
input name $ age height;
if age LE 10;
run;
How many observations will the WORK.HOMEWORK data set contain?
- A. 0
- B. No data set is created as the program fails to execute due to errors.
- C. 1
- D. 2
Answer: C
NEW QUESTION 180
......
REAL A00-211 Exam Questions With 100% Refund Guarantee : https://www.premiumvcedump.com/SASInstitute/valid-A00-211-premium-vce-exam-dumps.html