Chapter Review Quiz SAS logo

Controlling Input and Output

Select the best answer for each question. When you are finished, click Submit Quiz.

If the value of Region is missing (.), do these two DATA steps produce the same output?

data temperate tropical;
   set flora;
   select (region);
      when (1,4) output temperate;
      when (2,3,5) output tropical;
      otherwise;
   end;
run;

data temperate tropical;
   set flora;
   if Region in (1,4) 
      then output temperate;
   else if Region in (2,3,5) 
      then output tropical;
   else output;
run;

a. Yes

b. No

The data set shipping contains 25 observations and 3 variables (Product, BoxSize, and Rate). How many observations and variables does the data set shippingzones have?

data shippingzones;
   set shipping;
   Zone=1;
   output;
   Zone=2;
   Rate=(Rate*1.5);
   output;
   Zone=3;
   Rate=(Rate*1.5);
   output;
run;

a. 25 observations, 4 variables

b. 75 observations, 3 variables

c. 75 observations, 4 variables

If you submit the following program, which variables appear in the new data set?
data falltryout; set school.sports(keep=Month Sport Coach); if Month="Aug"; drop Month; run;
a.  Month, Sport, Coach

b.  Sport, Coach

c.  none

Which program contains an error?

data stresstest (drop=timemin timesec);
   set physical;
   TotalTime=(Timemin*60)+Timesec;
run;

proc print data=stressdata;
   label TotalTime='Duration of Test';
   drop TimeMin;
run;

proc print data=stresstest (keep=TotalTime TimeMin);
   label TotalTime='Duration of Test';
   format TimeMin 5.2;
run;

There are 300 observations in the trials data set. How many observations does the test data set contain?
data test; set trials(firstobs=150 obs=200); run;
a.  200

b.  201

c.  50

d.  51

Which of the following programs correctly reads july.orders data set and creates the fastorder data set?

data fastorder(drop=Ordertime);
   set july.orders(keep=Product Units Price);
   if Ordertime<4;
   Total=Units*Price;
run;

data orders(drop=Ordertime);
   set july.fastorder(keep=Product Units Price);
   if Ordertime<4;
   Total=Units*Price;
run;

data fastorder(drop=Ordertime);
   set july.orders(keep=Product Units Price Ordertime);
   if Ordertime<4;
   Total=Units*Price;
run;

Which of the following correctly writes observations to the tropical data set based on values of Region?

select region;
   when (2,3,5) output tropical;
   otherwise;
end;

select;
   when (region=2,3,5) output tropical;
   otherwise;
end;

select (region);
   when (2,3,5) output tropical;
   otherwise;
end;

What happens when you submit the following code?

data temperate tropical;
   set flora;
   output;
run;

a. Because the OUTPUT statement does not specify a data set, both output data sets are empty.

b. All observations in the flora data set are written to both output data sets.

c. The DATA step writes the first observation to each output data set and then stops processing because no RETURN statement is specified.