A00-215 Online Practice Questions and Answers

Given the partial shown below:

Which step will produce this report?

A. proc freq data=sashelp. shoes data=sashelp.shoes; region product / list run;

B. proc freq data=sashelp.shoes; tables region*producc / cross run;

C. proc freq data= sashelp, shoes order=freq; table region product / crosalist run;

D. proc freq data=sashelp. shoes order=freq; tables region*product / list; 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

Given the input data set WORK. GR_ANS with two character variables:

The following SAS program is submitted:

Which report is created?

A. Option A

B. Option B

C. Option C

D. Option D

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 program correctly subnets the SASHELP. BASEBALL data set to include only the players in the East Division with 75 or more hits?

A. data bball; set sashelp.baseball; whete Division and nHits run;

B. data bball; sot sashelp.baseball; where Division -- 'East; where nHits >= 75; run;

C. data bball; set sashelp.baseball; where Division = * East; or nHits .= 75;

D. data bball; set sashelp.basaball; whero Division -- 'Eas run,

Which statement is true about the DROP statement during the compilation phase of the DATA step?

A. The DROP statement flags the variables in the Program Data Vector to be dropped at output.

B. The DROP statement determines the order of the variables in the Program Data Vector

C. Variables on the DROP statement are removed from the input data set.

D. Variables on the DROP statement are not created in the Program Data Vector

Which statement is true regarding a variable?

A. A character variable can contain alphabetic characters, numeric digits, and other special characters.

B. A numeric value must be specified in single or double quotes.

C. A character value cannot exceed 200 bytes.

D. A numeric variable can contain digits, decimal point, minus sign, currency symbol, and E for scientific notation.

Which statement is true about the SUM statement?

A. The SUM statement includes an equal sign.

B. Multiple accumulating variables can be created with one SUM statement.

C. The SUM statement ignores missing values.

D. By default, the accumulating variable is initialized to 1.

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.