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: Aug 20, 2026

Add To Cart

Question 1

You have created a data table 'work.sales_data' using SAS procedures and want to use the 'table.save' method to store this data table permanently in the 'mydata' library. Which of the following code snippets correctly accomplishes this task, assuming that the 'mydata' library has already been assigned?

A : proc cas; table.save / table=work.sales_data caslib=mydata name="SalesDataPermanent"; run;

B : table.save / source=work.sales_data target=mydata.SalesDataPermanent; run;

C : saveTable / from=work.sales_data to=mydata.SalesDataPermanent; quit;

D : data mydata.SalesDataPermanent; set work.sales_data; run; quit;

Answer: A

Question 2

When defining a variable in a CAS table using PROC CAS, which of the following data types requires specifying the maximum length attribute?

A : double

B : varchar

C : int64

D : numeric

Answer: B

Question 3

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 4

You are working with a large, partitioned dataset in a CAS session and you want to ensure that a PROC MEANS calculation is performed in parallel across all data partitions to enhance performance. Which option would you use to accomplish this?

A : Use the PARTBY statement in the PROC MEANS code to specify the variable that defines the data partitions.

B : Explicitly define a BY statement and sort the data by the partitioning variable before calling PROC MEANS.

C : Use the NWAY option in the PROC MEANS code to enforce group processing only on the class variables.

D : Implement an ORDER BY clause in a preceding PROC SQL step to arrange the data by partitions.

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: Aug 20, 2026

Add To Cart