Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.171
The following SAS DATA step is submitted: data sasdata.atlanta
sasdata.boston work.portland work.phoenix;
set company.prdsales;
if region = #39;NE#39; then output boston; if region = #39;SE#39; then output atlanta;
if region = #39;SW#39; then output phoenix; if region = #39;NW#39; then output portland; run;
Which one of the following is true regarding the output data sets?
-
No library references are required.
-
The data sets listed on all the IF statements require a library reference.
-
The data sets listed in the last two IF statements require a library reference.
-
The data sets listed in the first two IF statements require a library reference.
Correct Answer: D
Question No.172
The following SAS program is submitted: data work.totalsales;
set work.monthlysales(keep = year product sales); retain monthsales {12} ;
array monthsales {12} ; do i = 1 to 12; monthsales{i} = sales; end;
cnt 1;
monthsales{cnt} = sales; run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
-
The program fails execution due to data errors.
-
The program fails execution due to syntax errors.
-
The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
-
The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations
Correct Answer: B
Question No.173
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: EMPLOYEE SALARY
name age name salary Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
The following SAS program is submitted: data work.empsalary;
merge work.employee (in = inemp) work.salary (in = insal);
by name;
if inemp and insal; run;
How many observations will the data set WORK.EMPSALARY contain?
A.
2
B.
4
C.
5
D.
6
Correct Answer: B
Question No.174
The following SAS program is submitted:
The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?
-
Gender
-
Department
-
Gender Department
-
Department Gender
-
Correct Answer: A
Question No.175
The contents of the raw data file CALENDAR are listed below:
-10-20-30
01012000
The following SAS program is submitted: data test;
infile #39;calendar#39;;
input @1 date mmddyy10.;
if date = #39;01012000#39;d then event = #39;January 1st#39;; run;
Which one of the following is the value of the EVENT variable? A. 01012000
-
January 1st
-
. (missing numeric value)
-
The value can not be determined as the program fails to execute due to errors
Correct Answer: D
Question No.176
Which step displays a listing of all the data sets in the WORK library?
-
proc contents lib=WORK run;
-
proc contents lib=WORK.all; run;
-
proc contents data=WORK._all_; run;
-
proc contents data=WORK _ALL_; run;
Correct Answer: C
Question No.177
A raw data record is listed below:
-10-20-30 1999/10/25
The following SAS program is submitted:
data projectduration; infile #39;file-specification#39;; input date $ 1 – 10; run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today#39;s date?
-
duration = today( ) – put(date,ddmmyy10.);
-
duration = today( ) – put(date,yymmdd10.);
-
duration = today( ) – input(date,ddmmyy10.);
-
duration = today( ) – input(date,yymmdd10.);
Correct Answer: D
Question No.178
Given the following raw data records in TEXTFILE.TXT:
The following output is desired:
Which SAS program correctly produces the desired output?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer: C
Question No.179
A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,quot;$64,000quot; SPLIT,1190,1,1,Rand Street,quot;$65,850quot; CONDO,1400,2,1.5,Market Street,quot;80,050quot; TWOSTORY,1810,4,3,Garris Street,quot;$107,250quot; RANCH,1500,3,3,Kemble Avenue,quot;$86,650quot;
SPLIT,1615,4,3,West Drive,quot;94,450quot; SPLIT,1305,3,1.5,Graham Avenue,quot;$73,650quot;
The following SAS program is submitted using the raw data file as input: data work.condo_ranch;
infile #39;file-specification#39; dsd; input style $ @;
if style = #39;CONDO#39; or style = #39;RANCH#39; then
input sqfeet bedrooms baths street $ price : dollar10.; run;
How many observations does the WORK.CONDO_RANCH data set contain?
A.
0
B.
3
C.
5
D.
7
Correct Answer: D
Question No.180
Given the contents of the raw data file #39;EMPLOYEE.TXT#39;
Which SAS informat correctly completes the program?
-
date9
-
mmddyy10
-
ddmmyy10
-
mondayyr10
-
Correct Answer: B
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF