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: Oct 28, 2025

Add To Cart

Question 1

In a multi-session SAS Viya environment, a data analyst needs to execute a DATA step that assigns a permanent library using the LIBNAME statement. The analyst needs to ensure that the dataset created within the DATA step is available in the assigned library for all subsequent sessions. Which DATA statement option should the analyst use to specify the session where the library and dataset will be accessible?

A : SESSREF=SASStudio

B : SESSREF=CASUSER

C : SESSREF=GLOBAL

D : SESSREF=ANALYSIS

Answer: C

Question 2

Consider the following SAS code which intends to retrieve values from an array to calculate the average sales for the first quarter: `data work.quarterly_sales;array qtr_sales[3];do i=1 to 3; set sales_data(keep=jan feb mar); qtr_sales[i] = sales_data{i};end;avg_sales = mean(of qtr_sales[*]);run;The dataset `sales_data` has three variables named `jan`, `feb`, and `mar`, containing the sales for each month of the first quarter. Which statement is true regarding this code?

A : The code will correctly calculate `avg_sales` as the average of the first quarter sales.

B : The `set` statement is incorrectly placed inside the loop, causing an error.

C : The mean function is not used correctly and will result in an error.

D : The array subscript cannot use `sales_data{i}`, it should be `qtr_sales[i] = sales_data[i];`.

Answer: B

Question 3

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 4

Which of the following is a true statement regarding variable scope in CASL?

A : Global variables declared outside of any function or action block are accessible only within the same script and cannot be accessed by other scripts or sessions.

B : CASL does not support local variables; all variables are global and can be accessed from any part of the program.

C : Variables in CASL are dynamically typed, and their scope is determined at runtime based on the execution context.

D : Local variables in CASL can be accessed and modified by any other blocks of code within the same action set.

Answer: A

Question 5

A programmer wants to utilize the `TABULATE` procedure in SAS Viya for generating a summary report. They need to limit the output to only include the observations for which the 'type' variable equals 'Residential'. Which option demonstrates the correct use of the `WHERE=` parameter in PROC TABULATE to accomplish this task?

A : `PROC TABULATE DATA=real_estate; WHERE= type = 'Residential'; CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

B : `PROC TABULATE DATA=real_estate TABULATE=WHERE(type = 'Residential'); CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

C : `PROC TABULATE DATA=real_estate; TABLE property_type, price*SUM / WHERE(Type = 'Residential'); CLASS property_type; VAR price; RUN;`

D : `PROC TABULATE DATA=real_estate(table=WHERE(type = 'Residential')); CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

Answer: A

Page: 1 / 59

Total 291 Questions | Updated On: Oct 28, 2025

Add To Cart