A00-215 Online Practice Questions and Answers

Given the display of the CITIES data set:

Which program creates the PROC PRINT report below?

A. proc print data=cities showlabelse; label Name= ' Employee Name City =Birth City

B. proc print data-cities label noobs; label Name='Employee Name' City=' Birth City' ; run;

C. proc print data=cities ; Name=' Employee Name' ; City='Birth City'; run;

D. options noobs labels; proc print data=cities; display Name=' Employee Name* city='Birth City', run;

The following program is summited:

The following report is created:

However, the desired report is shown below:

What change is needed to display the desired formatted values for the Answer varia

A. Change the unformatted values on the VALUE statement to upper case letters

B. Remove the comma located on the VALUE statement

C. Add a period to the end of the format name on the VALUE statement.

D. Remove the dollar sign located at the front of the format name

What is the default sort order of PROC SORT?

A. Internal

B. Ascending

C. Formatted

D. Descending

How many statements are in the following PROC PRINT step?

A. 5

B. 3

C. 4

D. 1

Which line contains a syntax error?

A. Line 3

B. Line 1

C. Line 2

D. Line 5

Which SAS format displays a SAS date as 25JUN2019?

A. ddMMMyy9.

B. Date9.

C. Ddmmmyyyy9.

D. Dmy9.

How does SAS display missing values?

A. a period for missing numeric and a blank for missing character

B. an N for missing numeric and C for missing character

C. a blank for Doth numeric and character missing

D. a blank for missing numeric and a $ for missing character

Given the following code:

Which variables are created with the BY statement?

A. State. First and State. Last

B. First. State and Last. State

C. First_State and Last_State

D. First. and Last.

Given the program shown below:

Given the partial PROC PRINT report below:

Why are the labels for msbp, MPG_city, and MPG_Highway NOT displaying in the PROC PRINT report^

A. You must use the LABEL option on the PROC PRINT statement

B. You must put the LABEL statement in the PROC PRINT step

C. You must put the LABEL statement after the KEEP statement In the DATA stop

D. You must use a single LABEL statement for each variable.

Given the PROC PRINT report of the INVEST data set shown below:

How many observations are in the FORCAST data set after this program executes?

A. 30

B. 10

C. 0

D. 20