__WORK.EMPLOYEE__

__fname age__

Bruce 30

Dan 40

__WORK.SALARY__

__fname salary__

Bruce 25000

Bruce 35000

Dan 25000

The following SAS program is submitted:

data work.empdata;

merge work.employee work.salary;

by fname;

totsal + salary;

run;

How many variables are output to the WORK.EMPDATA data set?

A. 3

B. 4

C. 5

D. No variables are output to the data set as the program fails to execute due to errors.

## 11 comments:

Answer: B

Name age salary totsal

Bruce 30 25000 25000

Bruce 30 35000 60000

Dan 40 25000 85000

its A

Answer A

The answer is A

Correct answer is B (4 observations).

Data Employee;

Input name $ age;

Datalines;

Bruce 30

Dan 40

;

Data SALARY;

infile datalines truncover;

Input name $ salary ;

Datalines;

Bruce 40000

Bruce 35000

Dan 37000

Dan

;

data work.empsalary;

merge work.employee (in = inemp)

work.salary (in = insal);

by name;

if inemp and insal;

run;

proc print data = empsalary;

run;

4 variables

SAS GURU IS right....answer is 4

GURU Of SAS GURU....

The answer is 4. The confusion is arising because the question is asking how many VARIABLES are in the output dataset, not how many OBSERVATIONS.

it is asking for variables and not observations

so answer is B 4 variables

FNAME, AGE, SALARY AND TOTSAL(NEW VARIABLE CREATED) = 4 VARIABLES.

For latest and updated SAS certification dumps in PDF format contact us at completeexamcollection@gmail.com.

Refer our blog for more details

http://completeexamcollection.blogspot.in/2015/12/sas-certification-dumps.html

## Post a Comment