SAS A00-215 Exam Practice Test Instant Access

Question 1

Given the code shown below:

What will be the format for MSRP in the RPOC PRINT output?

AThere is a syntax error in the FORMAT statement in the PROC PRINT step.

BComma12. 2

CDollar10.

DDollar12.

Answer : D

Question 2

The sashelp. class data set has 19 observations.

Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?

Apreteen will have 7 observations and teen will have 19 observations

Bpreteen will have 7 observations and teen will have 12 observations

Cpreteen will have 26 observations and teen will have 31 observations

Dpreteen will have 10 observations and teen will have 9 observations

Answer : C

Question 3

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?

A30

B10

D20

Answer : A

Question 4

Given the input data set WORK.RUN:

Given the following DATA step:

What is the correct output data set WORK.RUN2?

AOption

BOption

COption

DOption

Answer : D

Question 5

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^

AYou must use the LABEL option on the PROC PRINT statement

BYou must put the LABEL statement in the PROC PRINT step

CYou must put the LABEL statement after the KEEP statement In the DATA stop

DYou must use a single LABEL statement for each variable.

Answer : A

Question 6

Which code uses the correct syntax to conditionally create the two variables age-Cat and account?

Aif age<13 do than;
age_Cat= ' Pre-teen ';
,-account='No Social Media;'
and;

Bif age<13 then do;
age_cat=' Pre-teen'
account='No social Media' Allowed;'
and;
if age<13 then
age_Cat=;Pre-teen'
account='No Social Media Allowed';

Dif aga<13 do;
age_Cat-'Pre-teen';
account='No Social Media Allowed
end;

Answer : B

Question 7

The SAS log of a submitted DATA step is shown below:

Which action resolve the error messages?

ARemove the period after the value of Inc.

BEnclose the value of ABC Inc . in quotation marks.

CAdd a LENGTH statement to declare the company variable as character

DEnclose the value of ABC Inc. in parentheses.

Answer : A

SAS A00-215 SAS 9.4 Programming Fundamentals Exam Practice Test