SAS Institute A00-420 Practice Exams
Last updated on Oct 22,2026- Exam Code: A00-420
- Exam Name: SAS Viya Intermediate Programming
- Certification Provider: SAS Institute
- Latest update: Oct 22,2026
What is a CASLIB in CAS?
- A . A CAS action for data cleaning
- B . A CAS function for statistical analysis
- C . A CAS library for data storage and access
- D . A CAS procedure for data summarization
How can you rename a CAS table in CAS?
- A . Using the RENAME action
- B . Using the MODIFY action
- C . Using the EXPORT action
- D . Using the ALTER TABLE action
Which CAS-enabled procedure is used to perform data partitioning?
- A . CASPARTITION
- B . CASDATA
- C . CASTABULATE
- D . CASPROC
The following code is executed multiple times:
data casuser.eurorders;
set casuser.orders end=eof;
if Continent="Europe" then EurOrders+1;
if eof=1 then output;
keep EurOrders;
run;
proc print data=casuser.eurorders;
run;
Will the rows in the output table be sorted the same way for each execution and why?
- A . Yes, because only one row will be printed.
- B . Yes, because by default CAS sorts the output table.
- C . No, because each thread inserts a row into the casuser.eurorders table when it ends.
- D . No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.
What is the file extension used for SAS Viya programs?
- A . sas
- B . py
- C . sql
- D . viya
Which DATA step feature is NOT supported in CAS?
- A . DO Loops
- B . GIT functions
- C . Arrays
- D . IF-THEN/ELSE statements
Which CAS-enabled procedure allows the use of user-defined formats for data summarization?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC FORMAT
Which CAS action is used to calculate summary statistics for variables in a CAS table?
- A . cas.describe
- B . cas.stats
- C . cas.summary
- D . cas.aggregate
What is the purpose of the PROMOTE action in CAS?
- A . To create an index on a CAS table
- B . To promote a CAS table to an in-memory table
- C . To convert a CAS table to a different format
- D . To rename variables in a CAS table
Which PROC TRANSPOSE step will execute entirely in CAS?
- A . proc transpose data=casuser.table out=casuser.table_transposed;
id group;
run; - B . proc transpose data=casuser.table out=work.table_transposed;
id group;
run; - C . proc transpose data=work.table out=casuser.table_transposed;
id group;
run; - D . proc transpose data=work.table out=work.table_transposed;
id group;
run;