SAS Base Programming: A00-201

The following SAS program is submitted:

data work.report; set work.sales_info; if qtr(sales_date) ge 3; run;

The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.

How many of the original twelve observations in WORKSALES_INFO are written to the WORKREPORT data set?

A. 2

B. 3

C. 6

D. 9

Which one to the following SAS procedures displays the data portion of a SAS data set?

A. PRINT

B. FSLIST

C. CONTENTS

D. DATASETS

The SAS data sets WORKEMPLOYEE and WORKSALARY are shown 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;

by fname;

totsal + salary;

run;

Which one of the following statements completes the merge of the two data sets by the ENAME variable?

A. merge work.employee work.salary (fname = name);

B. merge work.employee work.salary (name = fname);

C. merge work.employee work.salary (rename = (fname = name));

D. merge work.employee work.salary (rename = (name = fname));