SAS Training

SAS Certified Base Programmer 50 Questions (11)

The following program is submitted:

proc contents data=sasuser.houses;
run;

The exhibit below contains partial output produced by the CONTENTS procedure.

Which of the following describes the Sasuser.Hourses data set?

a. The data set is sorted but not indexed.
b. The data set is both sorted and indexed.
c. The data set is not sorted but is indexed.
d. The data set is neither sorted nor indexed.

SAS Certified Base Programmer 50 Questions (10)

The SAS data set Sashelp.Prdsale contains the variables Region and Salary with 4 observations per Region. Sashelp.Prdsale is sorted primarily by Region and with Region by Salary in descending order.

The following program is submitted:

data one;
    set sashelp.prdsale;
    retain temp;
    by region descending salary;
        if first.region then
            do;
                temp=salary;
                output;
            end;
        if last.region then
            do;
                range=salary-temp;
                output;
            end;
run;

For each region, what is the number of observations(s) written to the output data set?

a. 0
b. 1
c. 2
d. 4

SAS Certified Base Programmer 50 Questions (9)

Which one of the following displays the contents of an external file from within a SAS session?

a. the LIST procedure

b. the PRINT procedure

c. the FSLIST procedure

d. the VIEWTABLE procedure

SAS Certified Base Programmer 50 Questions (8)

Which one of the following SAS date formats displays the SAS date value for January 16, 2002 in the form of 16/01/2002?

a. DATE10.

b. DDMMYY10.

c. WEEKDATE10.

d. DDMMYYYY10.

SAS Certified Base Programmer 50 Questions (7)

The following SAS program is submitted:

data newstaff;
    set staff;
    <insert WHERE statement here>
run;

Which one of the following WHERE statements completes the program and selects only observations with a Hire_date of February 23,2000?

a. where hire_date='23feb2000'd;

b. where hire_date='23feb2000';

c. where hire_date='02/23/2000'd;

d. where hire_date='02/23/2000';