Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpm65

A00-215 SAS Certified Associate: Programming Fundamentals Using SAS 9.4 Questions and Answers

Questions 4

Given the SAS data set WORK PRODUCTS:

A00-215 Question 4

How many variables does the WORK REVENUE data set contains?

Options:

A.

4

B.

5

C.

2

D.

3

Buy Now
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;

Buy Now
Questions 6

Which LIBNAME statement has the correct syntax for accessing SAS data sets?

Options:

A.

libname 'c:\sas\data' mydata;

B.

libname mydata 'c:\sas\data';

C.

libname mydata='c:\sas\data';

D.

libname 'c:\sas\data'=mydata;

Buy Now
Questions 7

The following program is summited:

A00-215 Question 7

The following report is created:

A00-215 Question 7

However, the desired report is shown below:

A00-215 Question 7

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

Options:

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

Buy Now
Questions 8

Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?

Options:

A.

libname xlsx exlib "c:\class.xlsx";

proc print data=xlsx.class_test;

run;

B.

libname exlib xlsx "c:\class.xlsx";

proc print data=class_test.xlsx;

run;

C.

libname exlib xlsx "c:\class";

proc print data=exlib.class_test.xlsx;

run;

D.

libname exlib xlsx "c: \class.xlsx";

proc print data=exlib.class_test;

run;

Buy Now
Questions 9

Which two statements are true about data set options such as KEEP= and RENAME =? (Choose two.)

Options:

A.

The options must be placed in parentheses.

B.

The options are not allowed in PROC steps.

C.

The options can be used only on the output data set.

D.

The options are placed after the data set name.

Buy Now
Questions 10

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
Questions 11

Which statement is true regarding a variable?

Options:

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.

Buy Now
Questions 12

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 13

Which line contains a syntax error?

A00-215 Question 13

Options:

A.

Line 3

B.

Line 1

C.

Line 2

D.

Line 5

Buy Now
Questions 14

Given the partial report shown below:

A00-215 Question 14

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 15

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 16

Given the display of the CITIES data set:

A00-215 Question 16

Which program creates the PROC PRINT report below?

A00-215 Question 16

Options:

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;

Buy Now
Questions 17

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 18

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 19

Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below:

A00-215 Question 19

A00-215 Question 19

Options:

A.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=0 and inD-0;

run;

B.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

run;

C.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=1 and inD-0;

run;

D.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=1 and inD-1;

run;

Buy Now
Questions 20

Which statement is true regarding the XLSX engine in the LIBNAME statement?

Options:

A.

The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.

B.

The XLSX engine can road and write data in Microsoft Excel workbooks.

C.

The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions

D.

The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement

Buy Now
Questions 21

Given the STUDENTS data set below:

A00-215 Question 21

What will be the values for First. State and Last. State for Ellen's observation?

Options:

A.

First. State=0 and Last. State=1

B.

First. State=0 and Last.State=0

C.

First. State=1 and Last. State=1

D.

First. State=1 and Last.State=0

Buy Now
Questions 22

Given the report shown below:

A00-215 Question 22

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;

Buy Now
Questions 23

Given the data set NAMES:

A00-215 Question 23

Which PROC SORT program creates the NAMES data set shown below?

A00-215 Question 23

Options:

A.

proc sort data=Names;

by Name;

run;

B.

proc sort data=Names;

orderby Name;

run;

C.

proc sort data=Names;

by Age;

run;

D.

proc sort data=Names;

orderby Age;

run;

Buy Now
Exam Code: A00-215
Exam Name: SAS Certified Associate: Programming Fundamentals Using SAS 9.4
Last Update: Jul 13, 2024
Questions: 78

PDF + Testing Engine

$56  $159.99

Testing Engine

$42  $119.99
buy now A00-215 testing engine

PDF (Q&A)

$35  $99.99
buy now A00-215 pdf
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 20 Jul 2024