NEW QUESTION 36
Given the raw data file YEARAMT:
—-|—10—|—20—|—-30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile ‘yearamt’;
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

NEW QUESTION 37
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?

NEW QUESTION 38
The following SAS program is submitted:

What is the value of the variable var1?

NEW QUESTION 39
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

NEW QUESTION 40
The following SAS program is submitted:
data work.accounting;
set work.dept1 work.dept2;
jobcode = ‘FA1’;
length jobcode $ 8;
run;
A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
What is the length of the variable JOBCODE in the output data set?

NEW QUESTION 41
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.; The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

NEW QUESTION 42
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile ‘file-specification’ end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?

NEW QUESTION 43
The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?

NEW QUESTION 44
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?

NEW QUESTION 45
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?

NEW QUESTION 46
There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

What will be the value of NewVar when SAS writes the last observation?

NEW QUESTION 47
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

NEW QUESTION 48
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?

NEW QUESTION 49
The following SAS program is submitted:
data work.test;
First = ‘Ipswich, England’;
City_Country = substr(First,1,7)!!’, ‘!!’England’;
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

NEW QUESTION 50
CORRECT TEXT
Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?
Enter your numeric answer in the space below.

NEW QUESTION 51
Given the SAS data set WORK.ONE:

What value will SAS assign to Total?

NEW QUESTION 52
The following SAS program is submitted:
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Which one of the following is the value of the DATE variable?

NEW QUESTION 53
The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.
Which one of the following is the length of the variable JOBCODE in the output data set?

NEW QUESTION 54
The following SAS program is submitted:

What is the initial value of the variable Total in the following program?

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

Which SAS informat correctly completes the program?

NEW QUESTION 56
The contents of the raw data file NAMENUM are listed below:
——–10——-20——-30
Joe xx
The following SAS program is submitted:
data test;
infile ‘namenum’;
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?

NEW QUESTION 57
Given the following SAS log entry:

What caused the error?