A00-231 Exam Question 16

The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
  • A00-231 Exam Question 17

    The following SAS program is submitted:

    If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
  • A00-231 Exam Question 18

    The following SAS program is submitted:
    data work.totalsales;
    set work.monthlysales(keep = year product sales);
    retain monthsales {12} ;
    array monthsales {12} ;
    do i = 1 to 12;
    monthsales{i} = sales;
    end;
    cnt + 1;
    monthsales{cnt} = sales;
    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?
  • A00-231 Exam Question 19

    The SAS data set BANKS is listed below:
    BANKS
    name rate
    FirstCapital 0.0718
    DirectBank 0.0721
    VirtualDirect 0.0728
    The following SAS program is submitted:
    data newbank;
    do year = 1 to 3;
    set banks;
    capital + 5000;
    end;
    run;
    Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
  • A00-231 Exam Question 20

    Given the SAS data set WORK.ORDERS:

    The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
    Which of the following statement will correctly create the value and assign it to ship_note?