Independence Day - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

A00-215 Sample Questions Answers

Questions 4

Which LABEL statement has correct syntax?

Options:

A.

Label FName=’ First Name’ ;

LName =; Last Name‘ ;

B.

Label FName=’ First Name’

LName =’ Last Name‘ ;

C.

Label FName=’ First Name’ and

LName =’ Last Name‘ ;

D.

Label FName=’ First Name’ ,

LName =; Last Name‘ ;

Buy Now
Questions 5

Which statement is true regarding the SET statement?

Options:

A.

The SET statement specifies an input data set in the DATA step.

B.

The SET statement specifies an output data set in the PROC SORT step.

C.

The SET statement specifies an input data sot in the PROC SORT step

D.

The SET statement specifies an output data 5et in the DAI A step.

Buy Now
Questions 6

Which statement is true when creating two SAS data sets with a DATA step?

Options:

A.

Name both data sets in the DATA statement

B.

Use an OUT= option in the WHERE statement to output the observations to the appropriate data sets.

C.

Use a PUT statement to output the observations to the appropriate data sets.

D.

Use a separate SET statement for each data set.

Buy Now
Questions 7

What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

Options:

A.

Syntax error

B.

Logic error

C.

Special error

D.

Data error

Buy Now
Questions 8

Given the partial report shown below:

Which step will produce this report?

Options:

A.

proc freq data=sashelp. shoes order=freq;

tables region*product / list;

run;

B.

proc freq data=sashelp. shoes;

tables region product / list;

run;

C.

proc freq data=sashelp. shoes order=freq;

tables region product / crosslist;

run;

D.

proc freq data=sashelp. shoes;

tables region*product / crosslist;

run;

Buy Now
Questions 9

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

Options:

A.

if age<13 do then;

age_Cat='Pre-teen';

account='No Social Media Allowed';

end;

B.

if age<13 then do;

age_Cat-'Pre-teen';

account-'No Social Media';

end;

C.

if age<13 then

age_Cat-' Pre-teen'

account='No Social Media Allowed';

end;

D.

if age<13 do;

age_Cat-' Pre-teen';

account='No Social Media Allowed';

end;

Buy Now
Questions 10

Which PROC MEANS program creates the report below?

Options:

A.

proc means data-sashelp. shoes sum mean;

var Sales;

Class Product;

run;

B.

proc means data=sashelp. 'shoes

var Sale;

group Product;

run/

C.

Pror moans data-uashelp . shoes sum mean nobe;

by sales;

class product

D.

proc means data-esea= ashelp. shoes.

sum Salad;

mean Sales;

by product;

run."

Buy Now
Questions 11

Which assignment statement uses the SUBSTR function to extract the four-digit year from the value of date?

data days;

date="02Apr2019";

insert-statement-here

run;

Options:

A.

year=substr (date, 7, 4) ;

B.

year=substr (date, 4, 6) ;

C.

year=substr (date, 6, 4) ;

O D) year=substr (date, 4, 7) ;

Buy Now
Questions 12

Which program generates the PROC MEANS report below?

Options:

A.

proc means data=sashelp.class nodec;

class Age; run;

B.

proc means data=sashelp. class;

group Age;

run;

C.

proc means data=sashelp. class;

by Age;

run;

D.

proc means data=sashelp. class maxdec=0;

var Age;

run;

Buy Now
Questions 13

Which step reads the SASHELP. BASEBALL data set and creates the temporary data set CATCHERS?

Options:

A.

data sashelp. catchers;

set sashelp.baseball;

where position='c';

run;

B.

data sashelp.baseball;

set catchers;

where position='c';

run;

C.

data sashelp.baseball;

set sashelp.catchers;

where position='c';

run;

D.

data catchers;

set sashelp.baseball;

where position='c';

run;

Buy Now
Questions 14

Which program correctly subnets the SASHELP. BASEBALL data set to include only the players in the East Division with 75 or more hits?

Options:

A.

data bball;

set sashelp.baseball;

where Division and nHits in ('East' and 75+);

run;

B.

data bball;

set sashelp.baseball;

where Division = 'East';

where nHits >= 75;

run;

C.

data bball;

set sashelp.baseball;

where Division - 'East' or nHits >= 75;

run;

D.

data bball;

set sashelp.baseball;

where Division = 'East' and nHits >= 75;

run;

Buy Now
Questions 15

Given the code shown below:

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

Options:

A.

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

B.

Comma12. 2

C.

Dollar10.

D.

Dollar12.

Buy Now
Questions 16

Given the input data set INVENTORY as shown below:

Two output data sets are desired, CHIPS and OTHERSNACKS.

* The CHIPS data set should only include QtySold, Price, and Product.

* The OTHERSNACKS data set should include QtySold, Price, product, and Type.

Which Data step creates the two desired output data sets

Options:

A.

data chips othersnacks;

set inventory;

if Type="chips" then do;

keep Qtysold Price Product;

output chips;

end;

else output othersnacks;

run;

B.

data chips (keep=QtySold Price Product) othersnacks;

set inventory;

if Type="chips" then output chips;

else output othersnacks;

run;

C.

data chips othersnacks;

set inventory;

if Type="chips" then output chips;

else output othersnacks;

keep QtySold Price Product;

run;

D.

data chips othersnacks;

set inventory (keep=QtySold Price Product) ;

if Type="chips" then output chips;

else output othersnacks;

run;

Buy Now
Questions 17

Which PROC PRINT statement controls the order of the variables displayed in the report?

Options:

A.

KEEP

B.

DROP

C.

VAR

D.

SELECT

Buy Now
Questions 18

Which PROC MEANS step generates the report below?

Options:

A.

proc means data=class mean std;

var Height Weight;

run;

B.

proc means data=class / mean std;

mean (Height, Weight) ;

std (Height, Weight) ;

run;

C.

proc means data=class;

var mean std;

run;

D.

proc means data=class;

options mean std;

keep Height Weight;

run;

Buy Now
Questions 19

How does SAS display missing values?

Options:

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

Buy Now
Questions 20

Which two correctly create a SAS date value? (Choose two.)

Options:

A.

"10/19/2019"d

B.

mdy (10, 19, 2019)

C.

"190ct2019"d

D.

mdy (19, Oct, 2019)

Buy Now
Questions 21

Which statement is true regarding the DATA step?

Options:

A.

The DATA step can only read raw data files.

B.

The DATA step reads, processes and creates date

C.

The DATA step can output only one data set.

D.

The DATA step must be the first step in a program.

Buy Now
Questions 22

Which PROC MEANS statement specifies the numeric variables to analyze?

Options:

A.

BY

B.

CLASS

C.

TABLES

D.

VAR

Buy Now
Questions 23

Given the following assignment statement:

BirthDate = 15DEC2005’d;

Which statement is true?

Options:

A.

15DEC2005 'd is a character constant

B.

BirthDate is a numeric variable.

C.

The byte size of BirthDate is 9.

D.

The assignment statement contains a syntax error.

Buy Now
Exam Code: A00-215
Exam Name: SAS Certified Associate: Programming Fundamentals Using SAS 9.4
Last Update: Jul 12, 2024
Questions: 78
$56  $159.99
$42  $119.99
$35  $99.99
buy now A00-215