Free A00-420 Questions for SASInstitute SAS Viya Intermediate Programming A00-420 Exam as PDF & Practice Test Engine

Exam Code/Number: A00-420
Exam Name/Title: SAS Viya Intermediate Programming
Certification Provider: SASInstitute
Corresponding Certification: SAS Viya Programming Specialist

Exam Questions: 256
Updated On: Oct 04, 2026

Question #1

What is the purpose of the VALUE statement in PROC FORMAT?

A. To specify the format name and type

B. To define the appearance of formatted values

C. To assign a format to a variable

D. To define the range of values for a format

Discussion 0

Correct Answer: B Vote an answer

Question #2

Given the following program:
data casuser.noInput / sessref=casauto;
x=1;
run;
Which statement is true?

A. The DATA step produces an error.

B. The DATA step runs in CAS.

C. The DATA step runs on the SAS Compute Server.

D. The DATA step runs on the SAS Workspace Server.

Discussion 0

Correct Answer: B Vote an answer

Question #3

Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?

A. cas.summarize

B. cas.statistics

C. cas.describe

D. cas.profile

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which operator is used for assignment in SAS Viya?

A. ==

B. :=

C. =

D. EQ

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which programming language is primarily used in the DATA step for CAS programming?

A. R

B. Python

C. Java

D. SAS

Discussion 0

Correct Answer: D Vote an answer

Question #6

What is the purpose of the BY statement in CAS language programming?

A. To subset the data

B. To merge multiple tables

C. To group data by one or more variables

D. To specify the output format

Discussion 0

Correct Answer: C Vote an answer

Question #7

Which SAS Viya procedure is used for statistical modeling and regression analysis?

A. PROC MEANS

B. PROC FREQ

C. PROC SQL

D. PROC GLM

Discussion 0

Correct Answer: D Vote an answer

Question #8

Which statement is true about the CAS server?

A. Any SAS program can run on the CAS server.

B. A CAS session is required to work with the CAS server.

C. An action set performs a single task on the CAS server.

D. A DATA Step always runs faster on the CAS server.

Discussion 0

Correct Answer: B Vote an answer

Question #9

Which statement can execute successfully using PROC FEDSQL?

A. create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
from casuser.heart
where cholesterol is null
;

B. create table work.age12 as
select Name, Height, Weight
from casuser.class
where age=12
;

C. select Species, SepalWidth, SepalLength
from casuser.iris
where Species ^= "Setosa"
;

D. select HouseID, Brand, exp(logPrice) as Price
from casuser.margarin
where calculated Price > 5
;

Discussion 0

Correct Answer: A Vote an answer

Question #10

Which CAS action is used to generate a random sample from a CAS table?

A. cas.fetch

B. cas.sample

C. cas.select

D. cas.random

Discussion 0

Correct Answer: B Vote an answer

Question #11

Given the following SAS program?
caslib _all_ assign;
proc sgplot data=casuser.cars;
vbar Make;
run;
What will the program do?

A. Execute the SGPLOT procedure on the CAS server.

B. Summarize the results in CAS and process the summarized results on the Compute Server.

C. Transfer the data to the Compute Server and then execute the SGPLOT procedure.

D. Produce an error because the SGPLOT procedure cannot access the CAS table.

Discussion 0

Correct Answer: C Vote an answer

Question #12

The regnm format has been created and stored in an CAS format library.
Which program associates the format regnm with the region column in the orders table?

A. proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public";
quit;

B. proc casutil;
load data=work.orders casout="orders" outcaslib="public";
format region regnm.;
quit;

C. proc casutil;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
format region regnm.;
quit;

D. proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
quit;

Discussion 0

Correct Answer: A Vote an answer

Question #13

Which CAS action is used to perform aggregations and summary statistics?

A. DESCRIBE

B. AGGREGATE

C. SUMMARIZE

D. SUMMARY

Discussion 0

Correct Answer: D Vote an answer

Question #14

How can you associate a user-defined format with a variable in SAS?

A. Using the FORMAT statement in the DATA step

B. Using the LABEL statement in PROC FORMAT

C. Using the BY statement in PROC FORMAT

D. Using the WHERE statement in PROC SQL

Discussion 0

Correct Answer: A Vote an answer

Question #15

Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

A. CASDATALIMIT=

B. NOCOMPUTE

C. MAXDATA=

D. MAXOBS=

Discussion 0

Correct Answer: A Vote an answer

Free A00-420 Questions for SASInstitute SAS Viya Intermediate Programming A00-420 Exam as PDF & Practice Test Engine

Download Free SASInstitute A00-420 Demo