A00-231 Exam Question 1

CORRECT TEXT
Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?
Enter your numeric answer in the space below.

A00-231 Exam Question 2

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?
  • A00-231 Exam Question 3

    The following SAS program is submitted:
    data work.accounting;
    set work.dept1 work.dept2;
    jobcode = 'FA1';
    length jobcode $ 8;
    run;
    A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
    What is the length of the variable JOBCODE in the output data set?
  • A00-231 Exam Question 4

    The following SAS program is submitted:
    data WORK.DATE_INFO;
    Day="01" ;
    Yr=1960 ;
    X=mdy(Day,01,Yr) ;
    run;
    What is the value of the variable X?
  • A00-231 Exam Question 5

    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?