Pass SAS Institute Systems A00-231 exam [Jan 15, 2023] Updated 265 Questions [Q157-Q172]

Q157. Given the SAS data set WORK.PRODUCTS:

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

Q158. Given the SAS data set WORK.ONE:

What value will SAS assign to Total?

Q159. The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?

Q160. The following SAS program is submitted:
options pageno = 1;
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
The report created by the PRINT procedure step generates 5 pages of output.
What is the page number on the first page of the report generated by the MEANS procedure step?

Q161. The following SAS program is submitted:
data work.totalsales;
set work.monthlysales(keep = year product sales);
retain monthsales {12} ;
array monthsales {12} ;
do i = 1 to 12;
monthsales{i} = sales;
end;
cnt + 1;
monthsales{cnt} = sales;
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?

Q162. 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?

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

Q164. The contents of the raw data file CALENDAR are listed below:
——–10——-20——-30
01012000
The following SAS program is submitted:
data test;
infile ‘calendar’;
input @1 date mmddyy10.;
if date = ‘01012000’d then event = ‘January 1st’;
run;
Which one of the following is the value of the EVENT variable?

Q165. The following SAS program is submitted:

What will the data set WORK.TEST contain?

Q166. The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 – difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?

Q167. The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?

Q168. Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

Q169. 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?

Q170. Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.
Which statement regarding this program is true?

Q171. The following SAS program is submitted:

Which statement is true about the output data set?

Q172. The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?