QUESTION 66
Given the contents of the raw data file ‘EMPLOYEE.TXT’

Which SAS informat correctly completes the program?

QUESTION 67
The following program is submitted:

Why does the program fail?

QUESTION 68
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?

QUESTION 69
Given the SAS data set PRICES:
PRICES
Prodid priceproducttypesalesreturns
K1255.10NETWORK152
B132S 2.34HARDWARE30010
R18KY2 1.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter cheap;
set prices(keep = productype price);
if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output inter; if price le 5.00; run; if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output inter; if price le 5.00; run; How many observations does the HWARE data set contain?

QUESTION 70
The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

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

QUESTION 72
The following SAS program is submitted:

What will the data set WORK.TEST contain?

QUESTION 73
The SAS data set EMPLOYEE_INFO is listed below:
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;
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

QUESTION 74
Given the contents of the raw data file EMPLOYEE:
—-|—-10—-|—-20—-|—-30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile ’employee’;
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?

QUESTION 75
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?

QUESTION 76
The following SAS program is submitted:
data revenue;
set year_1;
var1 = mdy(1,15,1960);
run;
Which one of the following values does the variable named VAR1 contain?

QUESTION 77
Given the raw data file EMPLOYEE.TXT:

The following SAS program is submitted:

What value does the variable idnum contain when the name of the employee is “Ruth”?

QUESTION 78
The following SAS program is submitted:
data work.test;
Author = ‘Christie, Agatha’;
First = substr(scan(author,2,’ ,’),1,1);
run;
Which one of the following is the value of the variable FIRST in the output data set?

QUESTION 79
The following SAS program is submitted:
libname company ‘SAS-data-library’;
proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?

QUESTION 80
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

QUESTION 81
Given the raw data file AMOUNT:
—-I—- 10—I—-20—I—-30
$1,234
The following SAS program is submitted:
data test;
infile ‘amount’;
input@1 salary 6.;
if_error_then description = ‘Problems’;
else description = ‘No Problems’;
run;
What is the result?

QUESTION 82
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

QUESTION 83
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:

The following program is submitted:

Which statement should be inserted to produce the following output?

QUESTION 84
The following SAS program is submitted:

What is the value of the variable Prod in the output data set?

QUESTION 85
Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

QUESTION 86
The following SAS program is submitted:
data work.retail;
cost = ‘20000’;
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?

QUESTION 87
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId.
Which statement is true about the output dataset?

QUESTION 88
The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 – sales4;
run;
Which one of the following represents the variables that are contained in the output data set?