A00-231 Exam Question 1

The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
  • A00-231 Exam Question 2

    The following SAS program is submitted:
    proc print data = sasuser.houses;
    run;
    proc means data = sasuser.shoes;
    run;
    Which one of the following OPTIONS statements resets the page number to 1 for the second report?
  • A00-231 Exam Question 3

    A raw data file is listed below:
    RANCH,1250,2,1,Sheppard Avenue,"$64,000"
    SPLIT,1190,1,1,Rand Street,"$65,850"
    CONDO,1400,2,1.5,Market Street,"80,050"
    TWOSTORY,1810,4,3,Garris Street,"$107,250"
    RANCH,1500,3,3,Kemble Avenue,"$86,650"
    SPLIT,1615,4,3,West Drive,"94,450"
    SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
    The following SAS program is submitted using the raw data file as input:
    data work.condo_ranch;
    infile 'file-specification' dsd;
    input style $ @;
    if style = 'CONDO' or style = 'RANCH' then input sqfeet bedrooms baths street $ price : dollar10.; run; How many observations does the WORK.CONDO_RANCH data set contain?
  • A00-231 Exam Question 4

    Which one of the following SAS statements renames two variables?
  • A00-231 Exam Question 5

    Given the SAS data set WORK.P2000:

    And the SAS data set WORK.P2008:

    The following output is desired:

    Which SAS program correctly combines the data?