Question 46
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
Question 47
The following SAS program is submitted:

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

What is the value of the second variable in the data set WORK.AUTHORS?
Question 48
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?
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?
Question 49
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
- style price
- CONDO$79,700
- TWOSTORY$62550
Which DEFINE statement completes the program and produces the desired output?
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
- style price
- CONDO$79,700
- TWOSTORY$62550
Which DEFINE statement completes the program and produces the desired output?
Question 50
This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?
