Question 21

The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = '1001';
Item_Reference = Item'/'Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
  • Question 22

    The following SAS program is submitted:
    data work.totalsales (keep = monthsales{12} );
    set work.monthlysales (keep = year product sales);
    array monthsales {12} ;
    do i=1 to 12;
    monthsales{i} = sales;
    end;
    run;
    The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
    Which one of the following is the result of the above program?
  • Question 23

    The following SAS program is submitted:
    data work.new;
    mon = 3;
    day = 23;
    year = 2000;
    date = mdy(mon,day,year);
    run;
    Which one of the following is the value of the DATE variable?
  • Question 24

    The following code was modified to generate the results further below:
    proc format;
    value agegrp
    low-12 ='Pre-Teen'
    13-high = 'Teen';
    run;
    proc means data=SASHELP.CLASS;
    var Height;
    class Sex Age;
    format Age agegrp.;
    run;
    The following results were generated to display only specific statistics and limit the decimals with the modification:

    Which statement below was modified or added to generate the results above:
  • Question 25

    Which one of the following is true of the RETAIN statement in a SAS DATA step program?