Advanced Programming SAS 9.4 Practice Exam: Questions 9

[TheresaM]

I feel like the practice exam must have been reviewed a thousand times for accuracy, so I feel silly asking this, but I really feel like the answer to Question 9 should be Bobby Bonilla. The question asks for the value of the NewName variable for observation 28 in the output data set:

The entire question is:

Write a SAS program that will:

• Use PROC FCMP to create a user-defined function called ReverseName to convert the variable name values from lastname, firstname to firstname lastname (Example: convert Wei, Zhang to Zhang Wei) Store the function in work.functions.dev.

• Use the following formula for the conversion:catx(" ", scan(name,2,","),scan(name,1,","))
  
  

• Create a new data set work.ACT01.

• Create this data set from the cert.names01 data set.

• Use the ReverseName function to create a new variable newName from the name variable.

• work.ACT01 should contain both the name and newName variables.

• When finished, sort the new data set by the newName variable in ascending order.

The correct code is below and the names.01 dataset is attached here.  

options cmplib=work.functions;
proc fcmp outlib=work.functions.dev;
	function ReverseName(name $) $40;
	return(catx(" ", scan(name,2,","),scan(name,1,",")));
	endsub;
quit;

data work.act01;
	set cert.names01;
	newName=ReverseName(name);
run;

Can someone try this and let me know if I am missing something? The answer key states that the correct response is "Bo Diaz" but that is the value for observation 79.

Thanks!

[ballardw · Accepted solution]

---

@TheresaM wrote:

I feel like the practice exam must have been reviewed a thousand times for accuracy, so I feel silly asking this, but I really feel like the answer to Question 9 should be Bobby Bonilla. The question asks for the value of the NewName variable for observation 28 in the output data set:

The entire question is:

Write a SAS program that will:

• Use PROC FCMP to create a user-defined function called ReverseName to convert the variable name values from lastname, firstname to firstname lastname (Example: convert Wei, Zhang to Zhang Wei) Store the function in work.functions.dev.

• Use the following formula for the conversion:catx(" ", scan(name,2,","),scan(name,1,","))
  
  

• Create a new data set work.ACT01.

• Create this data set from the cert.names01 data set.

• Use the ReverseName function to create a new variable newName from the name variable.

• work.ACT01 should contain both the name and newName variables.

• When finished, sort the new data set by the newName variable in ascending order.

The correct code is below and the names.01 dataset is attached here.  

options cmplib=work.functions;
proc fcmp outlib=work.functions.dev;
	function ReverseName(name $) $40;
	return(catx(" ", scan(name,2,","),scan(name,1,",")));
	endsub;
quit;

data work.act01;
	set cert.names01;
	newName=ReverseName(name);
run;

Can someone try this and let me know if I am missing something? The answer key states that the correct response is "Bo Diaz" but that is the value for observation 79.

Thanks!

---

Check the OBSERVATION NUMBER AFTER SORTING

[TheresaM]

Yes yes yes!  I knew that I was missing something, despite rereading the question a dozen times. This is the type of thing I need to watch out for during the exam.  Thank you @ballardw !!