Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.71
The Excel workbook REGIONS.XLS contains the following four worksheets: EAST
WEST NORTH SOUTH
The following program is submitted: libname MYXLS #39;regions.xls#39;;
Which PROC PRINT step correctly displays the NORTH worksheet?
-
proc print data=MYXLS.NORTH; run;
-
proc print data=MYXLS.NORTH$; run;
-
proc print data=MYXLS.#39;NORTH#39;e; run;
-
proc print data=MYXLS.#39;NORTH$#39;n; run;
Correct Answer: D
Question No.72
Given the SAS data set PRICES: PRICES
prodid price K12S5.10producttype NETWORKsales
15returns
B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted: data hware inter soft;
set prices (keep = producttype price); if price le 5.00;
if producttype = `HARDWARE#39; then output HWARE; else if producttype = `NETWORK#39; then output INTER; else if producttype = `SOFTWARE#39; then output SOFT; run;
How many observations does the HWARE data set contain?
A.
0
B.
2
C.
3
D.
4
Correct Answer: B
Question No.73
The following SAS program is submitted: Data_null_;
set old;
put sales 1 sales2; run;
Where is the output written?
-
to the SAS log
-
to the SAS data set _NULL_
-
to the SAS output window or to an output file
-
to the raw data file that was most recently opened
-
Correct Answer: A
Question No.74
The following SAS program is submitted: data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
-
2 temporary and 1 permanent SAS data sets are created
-
3 temporary and 2 permanent SAS data sets are created
-
2 temporary and 2 permanent SAS data sets are created
-
there is an error and no new data sets are created
Correct Answer: D
Question No.75
The following SAS program is submitted: data one;
addressl = `214 London Way#39;; run;
data one; set one;
address = tranwrd(address1, `Way#39;, `Drive#39;); run;
What are the length and value of the variable ADDRESS?
-
Length is 14; value is `214 London Dri#39;.
-
Length is 14; value is `214 London Way#39;.
-
Length is 16; value is `214 London Drive#39;.
-
Length is 200; value is `214 London Drive#39;.
Correct Answer: D
Question No.76
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: B
Question No.77
Given the following raw data record: 07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?
-
dmy9.
-
date9.
-
ddMMMyy9.
-
ddmmmyyyy9.
Correct Answer: B
Question No.78
Which program displays a listing of all data sets in the SASUSER library?
-
proc contents lib = sasuser.all; run;
-
proc contents data = sasuser.all; run;
-
proc contents lib = sasuser._alI_; run;
-
proc contents data = sasuser._all_; run;
Correct Answer: D
Question No.79
The following SAS program is submitted: libname temp `SAS data library#39;;
data work.new; set temp.jobs;
format newdate mmddw10.; mdate = month(newdate); ddate = weekday(newdate); run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday?
-
Obsnewdate mdate ddate 104/15/2005 APR 6
-
Obs newdate mdate ddate 104/15/2005 4 6
-
Obs newdate mdate ddate 104/15/2005 APR 7
-
Obs newdate mdate ddate 104/15/2005 4 7
Correct Answer: B
Question No.80
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;
lt;_insert_code_gt;
run;
-
tables region product;
-
tables region,product
-
tables region/product;
-
tables region*product;
Correct Answer: D
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF