SAS Chapter 4: Creating List Reports

Question 1

Which PROC PRINT step below creates the following output

Accepted Answer

proc print data=flights.laguardia label;
     id date;
     var boarded transferred flight;
     label boarded='On' transferred='Changed';
     where flight='219';
run;

Answer

proc print data=flights.laguardia noobs;
     var on changed flight;
     where on>=160;
run;

Answer

proc print data=flights.laguardia;
     var date on changed flight;
     where changed>3;
run;

Answer

proc print flights.laguardia noobs;
     id date;
     var date on changed flight;
     where flight='219';
run;

Question 2

Which of the following PROC PRINT steps is correct if labels are not stored with the data set?

Accepted Answer

proc print data=allsales.totals label;
     label region8='Region 8 Yearly Totals';
run;

Answer

proc print data=allsales.totals;
     label region8='Region 8 Yearly Totals';
run;

Answer

proc print data allsales.totals label noobs;
run;

Answer

proc print allsales.totals label;
run;

Question 3

Which of the following statements selects from a data set only those observations for which the value of the variable Style is RANCH, SPLIT, or TWOSTORY?

Accepted Answer

where style in ('RANCH','SPLIT','TWOSTORY');

Answer

where style='RANCH' or 'SPLIT' or 'TWOSTORY';

Answer

where style in 'RANCH' or 'SPLIT' or 'TWOSTORY';

Answer

where style in (RANCH, SPLIT, TWOSTORY);

Question 4

If you want to sort your data and create a temporary data set named Calc to store the sorted data, which of the following steps should you submit?

Accepted Answer

proc sort data=finance.dividend out=work.calc;
     by account;
run;

Answer

proc sort data=work.calc out=finance.dividend;
run;

Answer

proc sort dividend out=calc;
      by account;
run;

Answer

proc sort from finance.dividend to calc;
     by account;
run;

Question 5

Which options are used to create the following PROC PRINT output?

Accepted Answer

the DATE and NONUMBER system option and the DOUBLE and NOOBS options in PROC PRINT

Answer

the DATE system option and the label option in PROC PRINT

Answer

the DATE and NONUMBER system options and the DOUBLE option in PROC PRINT

Answer

the DATE and the NONUMBER system options and the NOOBS option in PROC PRINT

Question 6

Which of the following statements can you use in a PROC PRINT step to create this output?

Accepted Answer

all of the above

Answer

var month instructors;
sum instructors aerclass walkjogrun swim;

Answer

var month;
sum instructors aerclass walkjogrun swim;

Answer

var month instructors aerclass;
sum instructors aerclass walkjogrun swim;

Question 7

What happens if you submit the following program?
proc sort data=clinic.diabetes;
run;
proc print data=clinic.diabetes;
     var age height weight pulse;
     where sex='F';
run;

Accepted Answer

The PROC SORT step generates errors and stops processing, but the PROC PRINT step runs successfully, printing observations in their original (unsorted) order.

Answer

The PROC PRINT step runs successfully, printing observations in their sorted order.

Answer

The PROC SORT step permanently sorts the input data set.

Answer

The PROC SORT step runs successfully, but the PROC PRINT step generates errors and stops processing.

Question 8

Choose the statement below that selects rows in which

the amount is less than or equal to $5000
	
		the account is 101-1092 or the rate equals 0.095.

Accepted Answer

where amount <= 5000 and 
     (account='101-1092' or rate eq 0.095);

Answer

where amount <= 5000 and 
     account='101-1092' or rate =0.095;

Answer

where (amount le 5000 and account='101-1092')
     or rate =0.095;

Answer

where amount <= 5000 or account='101-1092'
     or rate = 0.095;

Question 9

What does PROC PRINT display by default?

Accepted Answer

PROC PRINT displays all observations and variables in the data set, a column for observation numbers on the far left, and variables in the order in which they occur in the data set.

Answer

PROC PRINT does not create a default report; you must specify the rows and columns to be displayed.

Answer

PROC PRINT displays all observations and variables in the data set.  If you want an additional column for observation numbers, you can request it.

Answer

PROC PRINT displays columns in the following order: a column for observation numbers, all character variables, and all numeric variables.

SAS Chapter 4: Creating List Reports

Which PROC PRINT step below creates the following output

Which of the following PROC PRINT steps is correct if labels are not stored with the data set?

Which of the following statements selects from a data set only those observations for which the value of the variable Style is RANCH, SPLIT, or TWOSTORY?

If you want to sort your data and create a temporary data set named Calc to store the sorted data, which of the following steps should you submit?

Which options are used to create the following PROC PRINT output?

Which of the following statements can you use in a PROC PRINT step to create this output?

What happens if you submit the following program? proc sort data=clinic.diabetes; run; proc print data=clinic.diabetes; var age height weight pulse; where sex='F'; run;

If you submit the following program, which output does it create? proc sort data=finance.loans out=work.loans; by months amount; run; proc print data=work.loans noobs; var months; sum amount payment; where months<360; run;

Choose the statement below that selects rows in which the amount is less than or equal to $5000 the account is 101-1092 or the rate equals 0.095.

What does PROC PRINT display by default?

Choose the statement below that selects rows in which

the amount is less than or equal to $5000

the account is 101-1092 or the rate equals 0.095.