A00-231 Exam Question 56

The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?
  • A00-231 Exam Question 57

    Given the SAS data set QTR 1_REVENUE:
    destination revenue
    YYZ53634
    FRA62129
    FRA75962
    RDU76254
    YYZ82174
    The following SAS program is submitted:
    proc sort data = qtr1_revenue;
    by destination descending revenue; run;
    What is the first observation in the output data set?
  • A00-231 Exam Question 58

    The contents of the raw data file CALENDAR are listed below:
    --------10-------20-------30
    01012000
    The following SAS program is submitted:
    data test;
    infile 'calendar';
    input @1 date mmddyy10.;
    if date = '01012000'd then event = 'January 1st';
    run;
    Which one of the following is the value of the EVENT variable?
  • A00-231 Exam Question 59

    After a SAS program is submitted, the following is written to the SAS log:

    What issue generated the error in the log?
  • A00-231 Exam Question 60

    Given the SAS data set WORK.ONE:

    The following SAS program is submitted:

    The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :

    Which expression successfully completed the program and creates the variable DAY?