Practice A00-234 Exam Online

Question 1

Which PICTURE statement generates a date format that produces the following results when used with the Date column?

A : picture DateFmt (default=10) low-high='%m\\\/%d\\\/%Y' (datatype=datetime);

B : picture DateFmt (default=10 )low-high='%m\\\/%d\\\/%Y' (datatype=date);

C : picture DateFmt low-high='%m\\\/%d\\\/%Y' (datatype=date default=10);

D : picture DateFmt low-high='%m\\\/%d\\\/%Y' (datatype=date);

Answer: B

Question 2

Why would you want to store your macros in external files?

A : Your macros would be available for use in later SAS sessions.

B : You could easily share your macros with others.

C : You could edit your macros with any text editor.

D : All of the above.

Answer: D

Question 3

Given the following DATA step, what is the value of USNum and WordNum?

data work.Count;

Text='AUSTRALIA, ENGLAND, CANADA, AUSTRIA, ITALY, US, SPAIN';

USNum=count(Text,'CANADA');

WordNum=countw(Text);

run;

A :

0, 7

B : 3, 0

C : 1, 7

Answer: C

Question 4

What does the PREV method do?

A : Returns the first value in the underlying hash object.

B : Returns the next value in the underlying hash object.

C : Returns the previous value in the underlying hash object.

D : Returns the last value in the underlying hash object.

Answer: C

Question 5

Suppose you had the program below, and you wanted to concatenate the values from the libname and memname columns to create a call to %Report3 for each row of data read. Which option would correctly run the program below and generate a result?

data _null_;

set sashelp.vtable;

where libname='MC1' and memtype='DATA';

rc=_______________________;

run;

A : rc=dosubl(cats(%Report3,',libname,memname),')');

B : rc=dosubl(cats('%Report3(',catx(',',libname,memname),')'));

C :

rc=dosubl(catx(%Report3,',libname,memname),')');

D : rc=dosubl(catx(%Report3(',catx(',',libname,memname),')'));

Answer: B

Name:	SAS 9.4 Advanced Programming -- Performance-Based Delta
Exam Code:	A00-234
Certification:	SAS Administration
Vendor:	SAS Institute
Total Questions:	115
Last Updated:	Apr 23, 2024

SAS Institute A00-234