Question 1.
Given the following raw data record:
----|----10---|----20---|----30
son,Travis,
The following output is desired:
Obs relation firstname
1 son Travis

Which SAS program correctly reads in the raw data?

A. data family;
infile 'file specification';
input relation $ firstname $ / dlm = ',';
run;
B. options dlm = ',';
data family;
infile 'file specification';
input relation $ firstname $;
run;
C. data family ( dlm = ',');
infile 'file specification';
input relation $ firstname $;
run;
D. data family;
infile 'file specification' dlm = ',';
input relation $ firstname $;
run;

Answer: D

Question 2.
The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
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?

A. Obs newdate mdate ddate
    1 04/15/2005 APR 7
B. Obs newdate mdate ddate
    1 04/15/2005 4 6
C. Obs newdate mdate ddate
    1 04/15/2005 APR 6
D. Obs newdate mdate ddate
    1 04/15/2005 4 7

Answer: B

Question 3.
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;

run;

Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

A. by ascending Expenses IDNumber;
B. by IDNumber Expenses;
C. by ascending IDNumber ascending Expenses;
D. by Expenses IDNumber;

Answer: B

Question 4.
The following SAS program is submitted:
data work.totalsales (keep = monthsales{12});
set work.monthlysales (keep = year product sales);
array monthsales{12};
do i = 1 to 12;
monthsales{i} = sales;
end;
run;
The program fails execution due to syntax errors. 

What is the cause of the syntax error?

A. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
B. The variable MONTHSALES does not exist.
C. An array cannot be referenced on a KEEP data set option.
D. The KEEP= data set option should be (KEEP = MONTHSALES).

Answer: C

Question 5.
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.

Which statement is true?

A. The BY statement in the DATA step causes a syntax error.
B. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.
C. The statement payroll + wagerate; in the DATA step causes a syntax error.
D. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

Answer: D

Question 6.
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
B. . (missing numeric value)
C. 1
D. 0.001

Answer: B

Question 7.
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.

How many observations will the data set WORK.EMPSALARY contain?

A. 0
B. 5
C. 12
D. 7

Answer: A

Question 8.
The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;

What is the value of the CITY variable?

A. ' ' (missing character value)
B. Other
C. Copenh
D. Copenhagen

Answer: B

Question 9.
The following SAS program is submitted:
data work.sales;
do year = 1 to 5;
do month = 1 to 12;
x + 1;
output;
end;
end;
run;

How many observations are written to the WORK.SALES data set?

A. 60
B. 0
C. 1
D. 5

Answer: A

Question 10.
The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;

What is the result?

A. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
B. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
C. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
D. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.

Answer: A

	Web www.certsbraindumps.com