SAS Viya Fundamentals of Programming (A00-415) Free Practice Test

Question 1

In SAS Viya, what is the purpose of the DATA step?

A. To create and modify SAS datasets

B. To import external data into SAS

C. To perform data visualization

D. To generate statistical reports

Correct Answer: A

Question 2

Which CAS-enabled procedure is used to apply user-defined formats to variables?

A. CASPROC

B. CASTABULATE

C. CASFORMAT

D. CASUTIL

Correct Answer: B

Question 3

What is the purpose of the GROUP BY clause in SQL programming?

A. To group rows based on common values

B. To define the output columns

C. To sort the result set

D. To filter rows based on conditions

Correct Answer: A

Question 4

Which CAS action is used to create a new variable in a CAS table based on a conditional expression?

A. cas.transform

B. cas.calculate

C. cas.generate

D. cas.derive

Correct Answer: D

Question 5

Given the following SAS program:
proc mdsummary data=casuser.orders;
var RetailPrice;
output out=casuser.orders_sum;
run;
Which CAS action produces the same result as the code above without ERROR if you run it twice?

A. proc cas;
md.summary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum'};
quit;

B. proc cas;
simple.summary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum'};
quit;

C. proc cas;
simple.summary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum', replace=true};
quit;

D. proc cas;
simple.mdsummary / table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name='orders_sum', replace=true};
quit;

Correct Answer: C

Question 6

Which statement is true regarding BY group processing in the CAS DATA step?

A. The DATA step orders the rows within a BY group and then orders the BY groups in the output.

B. Every row in a BY group is sent to the same thread and processed as a group.

C. Using the BY statement automatically sends all DATA step processing to a single thread.

D. The data must be sorted before the DATA step begins processing.

Correct Answer: B

Question 7

What is the purpose of applying a user-defined format to a variable in SAS?

A. To change the data type of the variable

B. To modify the appearance of the variable's values

C. To apply data validation rules to the variable

D. To rename the variable

Correct Answer: B

Question 8

Which statement about the CASL language is true?

A. All CAS-enabled procedures are converted to CASL behind the scenes to run in CAS.

B. CASL code is submitted to the CAS server using PROC CASUTIL.

C. Actions in CASL are grouped into PROCs, and optional information is provided with parameters.

D. CASL runs actions on both the SAS Compute Server and in CAS.

Correct Answer: A

Question 9

Which CAS action is used to delete a CASLIB?

A. CASLIB

B. EXPORT

C. ALTER TABLE

D. DROP TABLE

Correct Answer: A

Question 10

Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

A. Option D

B. Option C

C. Option A

D. Option B

Correct Answer: C

Question 11

Given the following CASL program:
proc cas;
table.tableInfo result=res / caslib="casuser";
do row over res.tableInfo;
print row;
end;
run;
quit;
Which statement best describes the variable row in the above program?

A. Row is a dictionary containing key=value pairs with information on each table in caslib casuser.

B. Row is comma separated string containing name and additional information of tables in caslib casuser.

C. Row is string type variable that contains the name of a table in caslib casuser.

D. Row is an array containing the values with information on each table in caslib casuser.

Correct Answer: A

Question 12

Which CAS action is used to compute the frequency distribution of a categorical variable in a CAS table?

A. cas.distribution

B. cas.histogram

C. cas.tabulate

D. cas.frequency

Correct Answer: C

Welcome to TestSimulate

SASInstitute SAS Viya Fundamentals of Programming (A00-415) Free Practice Test