Question 81

This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:

The following program is submitted:

Which statement should be inserted to produce the following output?
  • Question 82

    The following SAS program is submitted:
    proc sort data = sasuser.houses out = houses;
    by style;
    run;
    proc print data = houses;
    run;
    Click on the Exhibit button to view the report produced.
    style bedrooms baths price
    CONDO 2 1.5 80050
    3 2.5 79350
    4 2.5 127150
    2 2.0 110700
    RANCH 2 1.0 64000
    3 3.0 86650
    3 1.0 89100
    1 1.0 34550
    SPLIT 1 1.0 65850
    4 3.0 94450
    3 1.5 73650
    TWOSTORY 4 3.0 107250
    2 1.0 55850
    2 1.0 69250
    4 2.5 102950
    Which of the following SAS statement(s) create(s) the report?
  • Question 83

    A raw data file is listed below:
    --------10-------20-------30
    squash 1.10
    apples 2.25
    juice 1.69
    The following SAS program is submitted using the raw data file above:
    data groceries;
    infile 'file-specification';
    input item $ cost;
    run;
    Which one of the following completes the program and produces a grand total for all COST values?
  • Question 84

    Given the SAS data set WORK.ORDERS:

    The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
    A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: "Order 9341 shipped on 02FEB2009".
    Which of the following statement will correctly create the value and assign it to Note?
  • Question 85

    Which one of the following is true when SAS encounters a data error in a DATA step?