Question 1

Suppose you do not specify the LIBRARY= option and your formats are stored in Work.Formats. How long do they exist?

Options :

A : only for the current procedure

B : only for the current SAS session

C : permanently

D : only for the current DATA step

Answer: B

Question 2

What happens if you merge the following data sets by the variable SSN?

Options :

A : The values of Age in the data set 2nd are set to missing.

B :

The values of Age in the data set 1st overwrite the values of Age in the data set 2nd.

C : The DATA step fails because the two data sets contain same-named variables that have different values.

D :

The values of Age in the data set 2nd overwrite the values of Age in the data set 1st.

Answer: D

Question 3

Which SAS statement associates the fileref Crime with the raw data file C:\States \Data\crime.dat?

Options :

A :

filename 'c:\states\data\crime' crime.dat;

B : fileref crime 'c:\states\data\crime.dat';

C : filename crime c:\states\data\crime.dat;

D : filename crime 'c:\states\data\crime.dat';

Answer: D

Question 4

Select the DO WHILE statement that would generate the same result as the program below.data work.invest; capital=100000; do until(Capital gt 500000); Year+1; capital+(capital*.10); end; run;

Options :

A : do while(Capital>500000);

B : do while(Capital ge 500000);

C : do while(Capital le 500000);

D : do while(Capital=500000);

Answer: C

Question 5

When you create a format with the VALUE statement, the new format's name cannot end with a number, cannot end with a period, and cannot be the name of a SAS format. Which of the following is also true?

Options :

A : The name must begin with a dollar sign ($) if used with a character variable.

B : The name must be at least two characters long.

C : The name cannot be the name of a data set variable.

D : The name must be at least eight characters long.

Answer: A

Free A00-231 Mock Exam – Practice Online Confidently

Buying Options: