Question 1

The following SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?
  • Question 2

    The following SAS program is submitted:
    data test;
    set sasuser.employees;
    if 2 le years_service le 10 then
    amount = 1000;
    else amount = 0;
    amount_per_year = years_service / amount
    run;
    What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
  • Question 3

    The contents of the raw data file AMOUNT are listed below:
    --------10-------20-------30
    $1,234
    The following SAS program is submitted:
    data test;
    infile 'amount';
    input @1 salary 6.;
    if _error_ then description = 'Problems';
    else description = 'No Problems';
    run;
    Which one of the following is the value of the DESCRIPTION variable?
  • Question 4

    Consider the data step:

    Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
  • Question 5

    The following SAS program is submitted:
    data work.report;
    set work.sales_info;
    if qtr(sales_date) ge 3;
    run;
    The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.
    How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set?