A00-211 Sample Questions & Answers

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

Enter your numeric answer in the space below.

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

The contents of the SAS data set PERM.JAN_SALES are listed below:

A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

Which one of the following SAS system options prevents the page number from appearing on a report?

Which SAS program correctly combines the data?

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?

The following SAS program is submitted:

The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.

Which statement is true?

The following SAS program is submitted:

proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;

Which of the following is true concerning the submitted program?

The following SAS program is submitted:

What output is generated?

After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?