Maximum Grades By Making ready With A00-231 Dumps UPDATED 2023 [Q104-Q122]

NO.104 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?

NO.105 Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

NO.106 Given the SAS data set WORK.PRODUCTS:

How many observations does the WORK.OUTDOOR data set contain?

NO.107 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?

NO.108 The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10
Which one of the following SAS programs created this data set?

NO.109 The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?

NO.110 The following SAS program is submitted:

What is the value of the variable var1?

NO.111 The following SAS DATA step is submitted:
libname temp ‘SAS-data-library’;
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?

NO.112 Given the SAS data set WORK.ONE:

The following SAS program is submitted:

What value will SAS assign to Total?

NO.113 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?

NO.114 The following SAS program is submitted:

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

NO.115 Which program displays a listing of all data sets in the SASUSER library?

NO.116 On which portion(s) of a SAS data set does the PRINT procedure report?

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

NO.118 The following SAS program is submitted:

How many raw data records are read during each iteration of the DATA step?

NO.119 When SAS encounters a data when reading from a raw data file, which action will occur?

NO.120 A raw data record is listed below:
——–10——-20——-30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile ‘file-specification’;
input date $ 1 – 10;
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today’s date?

NO.121 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?

NO.122 The following SAS program is submitted:

Which statement is true about the output data set?