SAS Chapter 4: Creating List Reports

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Moxleyv
M
Moxleyv
Community Contributor
Quizzes Created: 38 | Total Attempts: 21,899
| Attempts: 424
SettingsSettings
Please wait...
  • 1/10 Questions

    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?

    • 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');
Please wait...
SAS Chapter 4: Creating List Reports - Quiz
About This Quiz

This quiz assesses skills in creating list reports using SAS, focusing on PROC PRINT steps. It evaluates understanding of data labeling, selection, sorting, and output customization. Essential for learners aiming to master SAS reporting techniques.

Quiz Preview

  • 2. 

    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?

    • 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;

    Correct Answer
    A. Proc sort data=finance.dividend out=work.calc;      by account; run;
    Explanation
    In a PROC SORT step, you specify the DATA= option to specify the data set to sort. The OUT= option specifies an output data set. The required BY statement specifies the variable(s) to use in sorting the data.

    Rate this question:

  • 3. 

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

    • 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;

    Correct Answer
    A. Proc print data=allsales.totals label;      label region8='Region 8 Yearly Totals'; run;
    Explanation
    You use the DATA= option to specify the data set to be printed. The LABEL option specifies that variable labels appear in output instead of variable names.

    Rate this question:

  • 4. 

    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;

    • 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.

    Correct Answer
    A. The PROC SORT step generates errors and stops processing, but the PROC PRINT step runs successfully, printing observations in their original (unsorted) order.
    Explanation
    The BY statement is required in PROC SORT. Without it, the PROC SORT step fails. However, the PROC PRINT step prints the original data set as requested.

    Rate this question:

  • 5. 

    What does PROC PRINT display by default?

    • 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.

    Correct Answer
    A. 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.
    Explanation
    You can remove the column for observation numbers. You can also specify the variables you want, and you can select observations according to conditions.

    Rate this question:

  • 6. 
    Which of the following statements can you use in a PROC PRINT step to create this output? - ProProfs

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

    • 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

    Correct Answer
    A. All of the above
    Explanation
    You do not need to name the variables in a VAR statement if you specify them in the SUM statement, but you can. If you choose not to name the variables in the VAR statement as well, then the SUM statement determines their order in the output.

    Rate this question:

  • 7. 
    Which PROC PRINT step below creates the following output - ProProfs

    Which PROC PRINT step below creates the following output

    • 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;

    Correct Answer
    A. proc print data=flights.laguardia label;      id date;      var boarded transferred flight;      label boarded='On' transferred='Changed';      where flight='219'; run;
    Explanation
    The DATA= option specifies the data set that you are listing, and the ID statement replaces the Obs column with the specified variable. The VAR statement specifies variables and controls the order in which they appear, and the WHERE statement selects rows based on a condition. The LABEL option in the PROC PRINT statement causes the labels specified in the LABEL statement to be displayed.

    Rate this question:

  • 8. 

    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;

    Correct Answer
    A.
    Explanation
    Column totals appear at the end of the report in the same format as the values of the variables, so b is incorrect. Work.Loans is sorted by the Month and Amount, so c is incorrect. The program sums both Amount and Payment, so d is incorrect.

    Rate this question:

  • 9. 
    Which options are used to create the following PROC PRINT output? - ProProfs

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

    • 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

    Correct Answer
    A. The DATE and NONUMBER system option and the DOUBLE and NOOBS options in PROC PRINT
    Explanation
    The DATE and NONUMBER system options cause the output to appear with the date but without page numbers. In the PROC PRINT step, the DOUBLE option specifies double spacing, and the NOOBS option removes the default Obs column.

    Rate this question:

  • 10. 

    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.

    • 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;

    Correct Answer
    A. Where amount <= 5000 and       (account='101-1092' or rate eq 0.095);
    Explanation
    To ensure that the compound expression is evaluated correctly, you can use parentheses to group (account='101-1092' or rate eq 0.095)

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 14, 2013
    Quiz Created by
    Moxleyv
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.