Easily To Pass New A00-211 Premium Exam Updated [Aug 12, 2022]
A00-211 Certification All-in-One Exam Guide Aug-2022
NEW QUESTION 161
Given the SAS data set WORK.ORDERS:
The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date
value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note,
that shows a character value with the order_id, shipped date, and customer name. For example, given the
first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?
- A. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
- B. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
- C. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
- D. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
Answer: D
NEW QUESTION 162
Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO IDNumber Expenses 2542
100.00 3612
133.15 2198
234.34 2198
111.12
The following SAS program is submitted:
proc sort data = employee_info; <insert BY statement here> run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?
- A. by ascending IDNumber ascending Expenses;
- B. by Expenses IDNumber;
- C. by ascending Expenses IDNumber;
- D. by IDNumber Expenses;
Answer: D
NEW QUESTION 163
The following SAS program is submitted:
What new variables are created?
- A. Diff1, Diff2 and Diff3
- B. Difcount1, Difcount2 and Difcount3
- C. Janpt, Febpt, and Marpt
- D. Patients1, Patients2 and Patients3
Answer: B
Explanation:
Section: Volume A
NEW QUESTION 164
The following SAS program is submitted:
What is the value of the variable Prod in the output data set?
- A. . (missing numeric)
- B. 0
- C. 1
- D. 2
Answer: C
NEW QUESTION 165
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. A DO loop cannot be used because the variables referenced do not end in a digit.
- B. do i = mon tue wed thu fri;
- C. do i = 1 to 5;
- D. do weekly{i} = 1 to 5;
Answer: C
NEW QUESTION 166
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable
COUNTRYFEE with a format or 7.;
The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
- A. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
- B. The data step fails execution; there is no format for LOCALFEE
- C. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
- D. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.
Answer: C
NEW QUESTION 167
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?
- A. proc print data = sasuser.houses label; label price = "Sale Price"; run;
- B. proc print data = sasuser.houses; price = "Sale Price"; run;
- C. proc print data = sasuser.houses label; label price "Sale Price"; run;
- D. proc print data = sasuser.houses; label price = "Sale Price"; run;
Answer: A
Explanation:
Section: Volume A
NEW QUESTION 168
Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable
Month:
The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?
A:
B:
C:
D:
- A. Option A
- B. Option C
- C. Option B
- D. Option D
Answer: C
NEW QUESTION 169
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: D
NEW QUESTION 170
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- A. The _ERROR_ variable can be used in expressions in the DATA step.
- B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
- C. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
- D. The _ERROR_ variable contains the number of the observation that caused the data error.
Answer: A
Explanation:
Section: Volume A
Explanation/Reference:
NEW QUESTION 171
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?
- A. 0
- B. 1
- C. 2
- D. (missing numeric value)
Answer: B
Explanation:
Section: Volume A
NEW QUESTION 172
The following SAS program is submitted:
data combine; prefix='505'; middle='6465 '; end='09090'; <insert statement here>; run;
Which statement successfully completes the program so that TOTAL has a value of 505-646509090?
- A. total = catx('-', prefix, middle, end);
- B. total = prefix!!'-'!! left(middle)!!'-'!! end;
- C. total = cat('-', prefix, middle, end);
- D. total = prefix !!'-'!! middle ''!!'-'!! end;
Answer: A
NEW QUESTION 173
The following SAS program is submitted:
If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
- A. Unknown
- B. Senior Pilot
- C. ' ' (missing character value)
- D. SENIOR PILOT
Answer: A
NEW QUESTION 174
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?
- A. NUM CHAR 1 23 3 23
- B. NUM CHAR 1 23 3 23 1 77
- C. NUM CHAR 1 77 2
- D. No output is generated.
Answer: D
NEW QUESTION 175
Given the SAS data set WORK.P2000:
And the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION 176 
Given the following SAS log entry:
What caused the error?
- A. The CANCEL option is required with DATALINES.
- B. The INPUT statement should be after the DATALINES statement.
- C. A semi-colon is missing on the DATALINES statement.
- D. Character data must be specified in quotes.
Answer: C
NEW QUESTION 177
Given the SAS data set QTR 1_REVENUE:
destination revenue
YYZ 53634
FRA 62129
FRA 75962
RDU 76254
YYZ 82174
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue; run;
What is the first observation in the output data set?
- A. destination revenue
FRA 75962 - B. destination revenue
FRA 62129 - C. destination revenue
YYZ 82174 - D. destination revenue
YYZ 53634
Answer: A
NEW QUESTION 178
This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?
- A. variable 1: Department
variable 2: Gender - B. variable 1: Gender
variable 2: Department - C. variable 1: Gender
variable 2: Gender - D. variable 1: Department
variable 2: Department
Answer: C
NEW QUESTION 179
The following SAS program is submitted:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 180
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';
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations will the output data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION 181
The following SAS program is submitted:
data allobs;
set sasdata.origin (firstobs = 75 obs = 499);
run;
The SAS data set SASDATA.ORIGIN contains 1000 observations.
How many observations does the ALLOBS data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION 182
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
What is output?
- A. Option B
- B. Option A
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 183
......
Last A00-211 practice test reviews: Practice Test SASInstitute dumps: https://www.ipassleader.com/SASInstitute/A00-211-practice-exam-dumps.html