Question 46

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
  • Question 47

    The following SAS program is submitted:

    What is the value of the second variable in the data set WORK.AUTHORS?
  • Question 48

    The following SAS program is submitted:
    data work.passengers;
    if OrigPassengers = . then'
    OrigPassengers = 100;
    TransPassengers = 100;
    OrigPassengers = .;
    TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
    run;
    What is the value of the TOTALPASSENGERS variable in the output data set?
  • Question 49

    Read the table:
    Given the SAS data set SASUSER.HOUSES:
    Obsstylebedroomsbathspricesqteetstreet
    1CONDO21.5800501200MAIN
    2CONDO32.5793501300ELM
    3CONDO42.51271501400OAK
    4CONDO22.01107001100FIFTH
    5TWOSTORY43.01072502100SECOND
    6TWOSTORY21.0556501600WEST
    7TWOSTORY21.0692501450NORTH
    6TWOSTORY42.5102950 2000SOUTH
    The following SAS program is submitted:
    proc report data = sasuser.houses nowd headline;
    column style price;
    where price It 100000;
    <insert DEFINE statement here>
    define price / mean width = 9 format = dollar12.;
    title;
    run;
    The following output is desired:
    - style price
    - CONDO$79,700
    - TWOSTORY$62550
    Which DEFINE statement completes the program and produces the desired output?
  • Question 50

    This question will ask you to provide a line of missing code.
    The following SAS program is submitted:
    proc freq data = WORK.SALES;
    <insert code here>
    run;
    The following output is created by the FREQUENCY procedure:

    Which statement was used to complete the above program that produced the output?