QUESTION 148
The contents of the raw data file PRODUCT are listed below:
——–10——-20——-30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile ‘product’;
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?

QUESTION 149
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 150
The following SAS program is submitted:

What is the value of the second variable in the data set WORK.AUTHORS?

QUESTION 151
The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end;
run;
Which one of the following is the value of the variable CALLS in the output data set?

QUESTION 152
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

QUESTION 153
The following SAS program is submitted:
data work.report;
set work.sales_info;
if qtr(sales_date) ge 3;
run;
The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.
How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set?

QUESTION 154
The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?

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

QUESTION 156
The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 =’Pre-Teen’
13-high = ‘Teen’;
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification:

Which statement below was modified or added to generate the results above:

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

QUESTION 158
A raw data file is listed below:

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

QUESTION 159
The following output is created by the FREQUENCY procedure:

Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;

QUESTION 160
Which one of the following is true of the RETAIN statement in a SAS DATA step program?

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

QUESTION 162
The following SAS program is submitted:

What is the value of the variable Diff?

QUESTION 163
Which program displays a listing of all data sets in the SASUSER library?

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

QUESTION 165
The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?

QUESTION 166
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LocalFee and CountryFee in the output data set?

QUESTION 167
The following SAS DATA step executes on Monday, April 25, 2000:
data newstaff;
set staff;
start_date = today();
run;
Which one of the following is the value of the variable START_DATE in the output data set?

QUESTION 168
After a SAS program is submitted, the following is written to the SAS log:

What issue generated the error in the log?

QUESTION 169
The following SAS program is submitted:

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

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

QUESTION 171
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department.
The following SAS program is submitted:

What is the value of the variable Total before the first iteration of the data step?

QUESTION 172
Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group-1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?