Summer Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

SAS Certified Associate: Programming Fundamentals Using SAS 9.4 Question and Answers

SAS Certified Associate: Programming Fundamentals Using SAS 9.4

Last Update May 21, 2024
Total Questions : 78

We are offering FREE A00-215 SAS Institute exam questions. All you do is to just go and sign up. Give your details, prepare A00-215 free exam questions and then go for complete pool of SAS Certified Associate: Programming Fundamentals Using SAS 9.4 test questions that will help you more.

A00-215 pdf

A00-215 PDF

$35  $99.99
A00-215 Engine

A00-215 Testing Engine

$42  $119.99
A00-215 PDF + Engine

A00-215 PDF + Testing Engine

$56  $159.99
Questions 1

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="chipa" then output chips;

else output otharsnacks;

run;

C.  

data chips otharsnacks;

set inventory;

if Type="chips" then output chips

else output otharsnacks;

keep QtySold Price Product;

run;

D.  

data chips othersnack"

set inventory (keep=QtySold Price Product);

if Typo~"chips" then output chips;

else output othersnacks;

run;

Discussion 0
Questions 2

Which PROC PRINT option displays variable labels in the report?

Options:

A.  

SHOWLABELS

B.  

COLS

C.  

LABELS=

D.  

LABEL

Discussion 0
Questions 3

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.

Discussion 0
Questions 4

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^

Options:

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.

Discussion 0
Questions 5

Which iterative DO statement is invalid?

Options:

A.  

Do 100 to 1200 by 100;

B.  

Do num = 1.1 to 1.9 by 0.1;

C.  

Do year = 2000 to 2016 by 2;

D.  

Do reverse = 10 to 1 by -1;

Discussion 0
Questions 6

The data set Snacks contains three variables (productName, Flavor, and Price). Given the program shown below:

What is the type and length of SnackType?

Options:

A.  

Numeric, 8

B.  

Character, 7

C.  

Character, 8

D.  

Character, 5

Discussion 0
Questions 7

How many statements are In the program shown below?

Options:

A.  

9

B.  

6

C.  

10

D.  

2

Discussion 0
Questions 8

Given the report shown below:

Which PROC PREQ step creates the frequency report?

Options:

A.  

proc freq data= cars;

tables make drivetrain;

run;

B.  

proc freq data= cars;

tables make *drivetrain;

run;

C.  

proc freq data- cars;

tables drivetrain make;

run;

D.  

proc freq data- cars;

tables drivetrain* make;

run;

Discussion 0
Questions 9

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."

Discussion 0