Question 56

The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
  • Question 57

    Which one of the following is true when SAS encounters a data error in a DATA step?
  • Question 58

    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';
    input sqfeet bedrooms baths street $
    price: dollar10.;
    run;
    How many observations will the output data set contain?
  • Question 59

    The following SAS program is submitted:

    If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
  • Question 60

    The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
    WORK.EMPLOYEE WORK.SALARY
    fname age fname salary
    Bruce 30 Bruce 25000
    Dan 40 Bruce 35000
    Dan 25000
    The following SAS program is submitted:
    data work.empdata;
    merge work.employee
    work.salary;
    by fname;
    totsal + salary;
    run;
    How many variables are output to the WORK.EMPDATA data set?