Free SAS Institute A00-420 Exam Questions

Become SAS Institute Certified with updated A00-420 exam questions and correct answers

Page: 1 / 59

Total 291 Questions | Updated On: Dec 17, 2025

Add To Cart

Question 1

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

Question 2

When setting up a data step in a SAS Viya environment, your code needs to read a database table hosted on a remote server, which is registered as a library in SAS Viya's library manager. What would be the appropriate LIBNAME statement to ensure that your data step can access this table?

A : libname mylib base 'server_path_to_data';

B : libname mylib meta LIBRARY="RemoteServerLib";

C : libname mylib sasiohttp HOSTNAME="remoteserver.com";

D : libname mylib v9 'server_path_to_data';

Answer: B

Question 3

Assume that you are working with a large dataset in CAS, and you have a need to create a flag variable that indicates whether certain criteria are met. This flag is based on a calculation that you do not want to repeat in multiple places throughout your DATA step code. How can the `computedVarsProgram=` parameter be utilized to optimize performance and maintainability?

A : Use the `computedVarsProgram=` parameter to define the flag calculation and reference the flag variable later in the DATA step without redefining the calculation.

B : Set the `computedVarsProgram=` parameter to create a macro variable with the desired flag value so it can be used throughout the DATA step.

C : Apply the `computedVarsProgram=` parameter in multiple DATA steps so each one can perform the flag calculation independently.

D : Invoke the `computedVarsProgram=` parameter at the end of the DATA step to store the results of the flag calculation for subsequent steps.

Answer: A

Question 4

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 5

When using the dataStep action set in SAS Viya, you need to create a new table that includes a calculated column based on conditional processing of other columns in the data. Which of the following OPTIONS correctly demonstrates how to create a new variable that assigns a value of 'High' if the variable 'Sales' is above 1000 and 'Low' if 'Sales' is 1000 or below using the dataStep.runCode action?

A : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

B : datastep.runCode / code="data newTable; set oldTable; if Sales then if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

C : datastep.runCode / code="proc newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; end;";

D : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then do; Sales_Level = 'High'; end; else do; Sales_Level = 'Low'; end; run;";

Answer: A

Page: 1 / 59

Total 291 Questions | Updated On: Dec 17, 2025

Add To Cart