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 09, 2025

Add To Cart

Question 1

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

Question 2

A SAS programmer wants to delete certain observations from a data set 'sales' where the 'product_code' is '1234'. The data set is indexed by 'product_code'. Which combination of statements is the most efficient way to accomplish this task?

A : MODIFY sales; WHERE product_code = '1234'; REMOVE;

B : MODIFY sales; IF product_code = '1234'; DELETE;

C : REPLACE sales; IF product_code = '1234'; DELETE;

D : MODIFY sales BY product_code; IF product_code = '1234'; REMOVE;

Answer: B

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

You are given a raw data file with a variable that contains currency amounts, including a dollar sign, commas, and decimal points (e.g., "$1,234.56"). You need to create a new SAS dataset and ensure that these amounts are read as numeric values without the currency formatting. Which informat would appropriately read the variable as a numeric value?

A : COMMAw.d

B : DOLLARw.d

C : NUMERICw.d

D : DOLLARw.

Answer: A

Question 5

What is the correct way to use the CAS library to save the results of a procedure in SAS Viya?

A : Use a DATA step with the CASLIB statement to specify the target CAS library where the results should be saved.

B : Use the PROC COPY command with the TO= and FROM= options to move result tables to a specified CAS library.

C : Assign a libref to the desired CAS library and then specify that libref in the OUT= option of the procedure.

D : Result tables are automatically saved to the CAS library assigned to the user at login and no additional steps are required.

Answer: C

Page: 1 / 59

Total 291 Questions | Updated On: Apr 09, 2025

Add To Cart