PrepAwayTest A00-231 Dumps Real Exam Questions Test Engine Dumps Training [Q54-Q68]

QUESTION 54
On which portion(s) of a SAS data set does the PRINT procedure report?

QUESTION 55
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?

QUESTION 56
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?

QUESTION 57
The contents of the raw data file FURNITURE are listed below:
——–10——-20——-30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile ‘furniture’ dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

QUESTION 58
Which statement correctly computes the average of four numerical values?

QUESTION 59
Given the following data step:

After data step execution, what will data set WORK.GEO contain?

QUESTION 60
Given the SAS data set QTR 1_REVENUE:
destination revenue
YYZ53634
FRA62129
FRA75962
RDU76254
YYZ82174
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?

QUESTION 61
The following SAS program is submitted:

What is the result?

QUESTION 62
Which of the following programs correctly invokes the DATA Step Debugger?

QUESTION 63
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?

QUESTION 64
Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

QUESTION 65
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?

QUESTION 66
Which one of the following is true when SAS encounters a data error in a DATA step?

QUESTION 67
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?

QUESTION 68
Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?