Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.161
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
-
libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;
copy mydata;
run;
-
libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;
keep mydata; run;
-
libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;
save mydata; run;
-
libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;
set mydata; run;
Correct Answer: D
Question No.162
The following SAS program is submitted:
What is the value of the second variable in the data set WORK.AUTHORS?
-
Hemingway
-
Hemingwa
-
#39; #39; (a missing value)
-
The program contains errors. No variables are created.
Correct Answer: B
Question No.163
The following SAS program is submitted: data work.staff;
JobCategory = #39;FA#39;; JobLevel = #39;1#39;;
JobCategory = JobCategory || JobLevel; run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?
-
FA
-
FA1
-
FA 1
-
#39; #39; (missing character value)
Correct Answer: A
Question No.164
On which portion(s) of a SAS data set does the PRINT procedure report?
-
the data portion only
-
the descriptor portion only
-
the descriptor portion and the data portion
-
neither the data portion nor the descriptor portion
Correct Answer: A
Question No.165
A SAS program is submitted and the following SAS log is produced: 2 data gt100;
-
set ia.airplanes
-
if mpg gt 100 then output; 22 202
ERROR: File WORK.IF.DATA does not exist. ERROR: File WORK.MPG.DATA does not exist. ERROR: File WORK.GT.DATA does not exist. ERROR: File WORK.THEN.DATA does not exist. ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored. 5 run;
The IA libref was previously assigned in this SAS session. Which one of the following corrects the errors in the LOG?
-
Delete the word THEN on the IF statement.
-
Add a semicolon at the end of the SET statement.
-
Place quotes around the value on the IF statement.
-
Add an END statement to conclude the IF statement
Correct Answer: B
Question No.166
The following SAS program is submitted: data work.test;
Author = #39;Agatha Christie#39;;
First = substr(scan(author,1,#39; ,#39;),1,1); run;
Which one of the following is the length of the variable FIRST in the output data set?
A.
1
B.
6
C.
15
D.
200
Correct Answer: D
Question No.167
Consider the following data step:
The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Which statement regarding this program is true?
-
The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
-
Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
-
The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
-
City#39;s value will be assigned one time, State#39;s value 5 times.
-
Correct Answer: D
Question No.168
The following SAS program is submitted: data work.products;
Product_Number = 5461;
Item = #39;1001#39;;
Item_Reference = Item#39;/#39;Product_Number; run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set? A. 1001/5461
B. 1001/ 5461
-
. (missing numeric value)
-
The value can not be determined as the program fails to execute due to errors.
Correct Answer: D
Question No.169
After a SAS program is submitted, the following is written to the SAS log:
What changes should be made to the KEEP statement to correct the errors in the LOG?
-
keep=(Product Sales);
-
keep Product, Sales;
-
keep=Product, Sales;
-
keep Product Sales;
Correct Answer: D
Question No.170
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
-
non-missing numeric variable values only
-
missing numeric variable values and non-missing numeric variable values only
-
non-missing character variables and non-missing numeric variable values only
-
missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values
Correct Answer: A
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF