A00-211 Online Practice Questions and Answers

Which ODS statement option terminates output being written to an HTML rile?

A. END

B. QUIT

C. STOP

D. CLOSE

The following SAS program is submitted:

What is produced as output?

A. A file named test.cvs that can only be opened in Excel.

B. A text file named test.cvs that can be opened in Excel or in any text editor.

C. A text file named test.cvs that can only be opened in a text editor.

D. A file named test.cvs that can only be opened by SAS.

The following SAS program is submitted:

data WORK.DATE_INFO;

Day="01" ;

Yr=1960 ;

X=mdy(Day,01,Yr) ;

run;

What is the value of the variable X?

A. the numeric value 0

B. the character value "01011960"

C. a missing value due to syntax errors

D. the step will not compile because of the character argument in the mdy function.

The following SAS program is submitted:

data work.test;

Title = 'A Tale of Two Cities, Charles J. Dickens';

Word = scan(title,3,' ,');

run;

Which one of the following is the value of the variable WORD in the output data set?

A. T

B. of

C. Dickens

D. ' ' (missing character value)

Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS informat correctly completes the program?

A. date9

B. mmddyy10

C. ddmmyy10

D. mondayyr10

Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

A. B. C. D.

The following SAS program is submitted:

What is the value of the variable var1?

A. `1/15/1960'

B. 15

C. 1151960

D. 14

Given the following SAS data set WORK.EMPDATA:

Which WERE statement would display observations wit Job_Title containing the word "Manager"? `))='MANAGER';

A. where upcase(scan(Job_Title,-1,'

B. where Job_Title like `Manager%';

C. where substr(Job_Title, (length(Job_Title)-6))='Manager';

D. where Job_Title='% Manager `;

This question will ask you to provide lines of missing code.

The following SAS program is submitted:

Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?

A. B. C. D.

Given the data set WORK.DEPARTMENTS:

The following SAS program is submitted: Which output will be generated?

A. B. C. D.