Free Practice SAS Institute A00-420 Exam Questions 2025

Stay ahead with 100% Free SAS Viya Intermediate Programming A00-420 Dumps Practice Questions

Page: 1 / 59

Total 291 Questions | Updated On: Apr 24, 2025

Add To Cart

Question 1

When creating a new computed column in a CAS table using the DATA step in SAS Viya, which of the following statements is NOT supported?

A : WHERE statement to subset data before the computation.

B : ARRAY statement to define arrays for use in computations.

C : MODIFY statement to update data in an existing CAS table.

D : DATALINES statement to include inline data in the DATA step.

Answer: C

Question 2

You have loaded a data set into a CAS session and need to perform a simple aggregation that summarizes total sales by region. Which of the following CAS actions allows you to do this most efficiently?

A : table.loadTable

B : simple.sum

C : aggregation.aggregate

D : fedSql.execDirect

Answer: C

Question 3

When working in a SAS Viya environment, a programmer intends to save a series of informats and formats so that they are shared across various sessions and persisted beyond the current session. They specify the CASFMTLIB= option in their PROC FORMAT code. Which of the following is a result of executing this code with the CASFMTLIB= option set?

A : The informats and formats are saved to the specified caslib and can be shared across sessions, but they are not persistent after the session ends.

B : The new informats and formats are only available to the current session and must be recreated in subsequent sessions.

C : The informats and formats are saved to the specified caslib and are persistent, meaning they are available to subsequent sessions without needing to be recreated.

D : The CAS session is terminated, and all informats and formats are saved to sashelp library.

Answer: C

Question 4

When performing a data manipulation task using the simple action set in SAS Viya, you need to group the data by the 'region' variable and then calculate the total sales for each region. Which action should you use to accomplish this task within the simple action set?

A : simple.groupby

B : aggregation.groupby

C : simple.summary

D : simple.aggregate

Answer: D

Question 5

A data analyst is using the fedSQL action set to combine data from separate tables stored in a distributed environment. They want to perform a left join on two tables, 'customers' and 'orders', based on the customer ID. Which of the following fedSQL statements accomplishes this?

A : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

B : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers LEFT JOIN orders ON customers.id = orders.customer_id; QUIT;

C : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers t1 LEFT JOIN orders t2 ON t1.customer_id = t2.customer_id; QUIT;

D : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers FULL JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

Answer: C

Page: 1 / 59

Total 291 Questions | Updated On: Apr 24, 2025

Add To Cart