SAS Chapter 4: Creating List Reports

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

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

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

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

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

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

Proc print data allsales.totals label noobs; run;

Proc print allsales.totals label; run;

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

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

Where style in (RANCH, SPLIT, TWOSTORY);

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

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

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

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

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

The DATE system option and the label option in PROC PRINT

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

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

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

Var month instructors; sum instructors aerclass walkjogrun swim;

Var month; sum instructors aerclass walkjogrun swim;

Var month instructors aerclass; sum instructors aerclass walkjogrun swim;

All of the above

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

The PROC SORT step permanently sorts the input data set.

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

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

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

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

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

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

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

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

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

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.