By admin | July 28, 2009

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.

Data Set Name SASUSER.HOUSES Observations 15
Member Type DATA Variables 6
Engine V9 Indexes 0
Created Tuesday, April 22, 2003 03:09:25 PM Observation Length 56
Last Modified Tuesday, April 22, 2003 03:09:25 PM Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label Residential housing for sale Data Representation WINDOWS_32
Encoding wlatin1 Western(Windows)

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.

By admin | July 28, 2009

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

By admin | July 28, 2009

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

By admin | July 28, 2009

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.

By admin | July 28, 2009

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';