Question 176
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?
Question 177
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 178
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
123 323 177
The following SAS program is submitted:
proc print data = one; where char = 23; run;
What is output?
Question 179
On which portion(s) of a SAS data set does the PRINT procedure report?
Question 180
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?
