http://https://www.lead1pass.com/SASInstitute/A00-211-practice-exam-dumps.html (218 Q&As Dumps, 30%OFF Special Discount: 30free )
NEW QUESTION NO: 8
The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
A. 0.001
B. 0
C. . (missing numeric value)
D. 1
Answer: C
NEW QUESTION NO: 9
Consider the following data step:
In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?
A. X would get a value of 3.
B. X would retain its original value of missing.
C. X would get a value of 1.
D. This step does not run because of syntax errors.
Answer: C
NEW QUESTION NO: 10
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 NO: 11
The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
A. . (missing numeric value)
B. 25.31
C. $25.31
D. No value is stored as the program fails to execute due to errors.
Answer: A
NEW QUESTION NO: 12
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
A. non-missing numeric variable values only
B. non-missing character variables and non-missing numeric variable values only
C. missing numeric variable values and non-missing numeric variable values only
D. missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values
Answer: A
NEW QUESTION NO: 13
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
A. CSVALL
B. MSOFFICE2K
C. EXCELXP
D. WINXP
Answer: D
NEW QUESTION NO: 14
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
A. The output displays only the variables in the SAS data sets that are contained in the WORK library.
B. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.
C. The output displays only the contents of the SAS data sets that are contained in the WORK library.
D. The output contains only a list of the SAS data sets that are contained in the WORK library.
Answer: B
NEW QUESTION NO: 15
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-6465-
09090?
A. total = prefix!!'-'!! left(middle)!!'-'!! end;
B. total = prefix !!'-'!! middle ''!!'-'!! end;
C. total = cat('-', prefix, middle, end);
D. total = catx('-', prefix, middle, end);
Answer: D
NEW QUESTION NO: 16
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
-----
22
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
,<=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?
A. (drop=Month Quantity Cost)
B. (drop=Month, Quantity, Cost)
C. (drop Month Quantity Cost)
D. (drop Month, Quantity, Cost)
Answer: A
NEW QUESTION NO: 17
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS NAME AGE
--------- ------ Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
A. ----I----10---I----20---I----30
Alfr14
Alic13
Barb13a
Carol 4
B. ----I----10---I----20---I----30
Alfr14ed
Alic130
Barb13ara
Caro141
C. ----I----10---I----20---I----30
Alfred 14
Alice 13
Barbara 13
Carol 14
D. ----I----10---I----20---I----30
Alfred14
Alice13
Barbara13
Carol14
Answer: A
NEW QUESTION NO: 18
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 Expenses IDNumber;
B. by ascending Expenses IDNumber;
C. by ascending IDNumber ascending Expenses;
D. by IDNumber Expenses;
Answer: D