Given the data set WORK.EMPDATA:

Which one of the following where statements would display observations with job titles containing the word 'Manager'?

• A.where Job_Title='% Manager ';
• B.where upcase(scan(Job_Title,-1,''))='MANAGER';
• C.where Job_Title like '%Manager%';
• D.where substr(Job_Title,(length(Job_Title)-6))='Manager';

Comment: *

Name: *

Email: *

Verification: *

Given the data sets below:
WORK.EMP with variables:

WORK.NEWHIRE with variables:

The following SAS program is submitted:

The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.
How many variables will the data set WORK.ALLEMP contain?

• A.6
• B.4
• C.3
• D.The program fails execution.

Comment: *

Name: *

Email: *

Verification: *

This project will use data set cert.input08a and cert.input08b. At any time, you may save your program as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
* Combine data sets cert.input08a and cert.input08b by matching values of the ID variable.
* Write only observations that are in both data sets to a new data set named results.match08.
* Write all other non-matching observations from either data set to a new data set named results.nomatch08.
* Exclude all variables that begin with "ex" from results.nomatch08.
How many observations (rows) are inresults.match08?
Enter your numeric answer in the space below:

Comment: *

Name: *

Email: *

Verification: *

What is the format for the variableNamein the data setBoth? Select one:

• A.$CHAR15
• B.$CHAR10
• C.$CHAR
• D.no format defined

Comment: *

Name: *

Email: *

Verification: *

CORRECT TEXT
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.

Comment: *

Name: *

Email: *

Verification: *