NEW QUESTION 42
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then’
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?

NEW QUESTION 43
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 44
Given the SAS data set ONE:
ONE
ObsDte
————-
109JAN2005
212JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:
TWO
ObsDteDay
109JAN20051
12JAN20054
Which expression successfully completed the program and created the variable DAY?

NEW QUESTION 45
The following SAS program is submitted:
data work.new;
length word $7;
amount = 7;
if amount = 5 then word = ‘CAT’;
else if amount = 7 then word = ‘DOG’;
else word = ‘NONE!!!’;
amount = 5;
run;
Which one of the following represents the values of the AMOUNT and WORD variables?

NEW QUESTION 46
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 data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?

NEW QUESTION 47
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

NEW QUESTION 48
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?

NEW QUESTION 49
The following SAS program is submitted:

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

NEW QUESTION 50
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 51
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

NEW QUESTION 52
Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE
—————- Alfred14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm ‘SAS data library’;
data students;
set perm.students;
file ‘file specification’;
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?

NEW QUESTION 53
When SAS encounters a data when reading from a raw data file, which action will occur?

NEW QUESTION 54
The SASDATA.BANKS data set has five observations when the following SAS program is submitted:
libname sasdata ‘SAS-data-library’;
data allobs;
set sasdata.banks;
capital=0;
do year = 2000 to 2020 by 5;
capital + ((capital+2000) * rate);
output;
end;
run;
How many observations will the ALLOBS data set contain?

NEW QUESTION 55
CORRECT TEXT
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:

The following SAS program is submitted:

In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.

NEW QUESTION 56
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = ‘Unknown’;
else if level = 1 then
expertise = ‘Low’;
else if level = 2 or 3 then
expertise = ‘Medium’;
else
expertise = ‘High’;
run;
Which of the following values does the variable EXPERTISE contain?

NEW QUESTION 57
Which one of the following SAS system options displays the time on a report?

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

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

NEW QUESTION 60
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?

NEW QUESTION 61
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = ‘Jan’ then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?

NEW QUESTION 62
What is the purpose or the MISSOVER option on the INFILE statement?

NEW QUESTION 63
Which statement describes a characteristic of the SAS automatic variable _ERROR_?

NEW QUESTION 64
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 WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?