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
Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?
- A . cas.aggregate
- B . cas.groupby
- C . cas.summarize
- D . cas.collapse
In the following code, complete the PRINT statement to print only rows where column begins with MPG:
proc cas;
simple.summary result=res /
table={name="cars"};
resultTable = res.summary;
print <insert code segment
here>;
run;
- A . resultTable.where(column like ‘MPG%’)
- B . resultTable.where("column like ‘MPG%’")
- C . resultTable / where("column like ‘MPG%’")
- D . resultTable / where(column like ‘MPG%’)
Which CAS action is used to create a new variable in a CAS table based on a conditional expression?
- A . cas.derive
- B . cas.calculate
- C . cas.transform
- D . cas.generate
Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?
- A . cas.count
- B . cas.unique
- C . cas.missing
- D . cas.summary
Which DATA step statement is used to read data from an external file in CAS programming?
- A . PROC SQL
- B . SET statement
- C . MERGE statement
- D . OUTPUT statement
Which statement is true for the table.copyTable action?
- A . Both the table= and casout= parameters are required to use the copyTable action.
- B . The table= parameter specifies the name of the table that you want to replace.
- C . The table= parameter allows you to create calculated columns.
- D . The casout= parameter is required, but the table= parameter is not required.
When loading a data set into memory using PROC CASUTIL and the LOAD statement, what option will set the in-memory table’s scope to GLOBAL?
Enter your answer in the space below: _________
Which CAS action is used to create a new CAS table based on specified conditions?
- A . FILTER
- B . SELECT
- C . WHERE
- D . SUBSET
Which CAS action is used to identify potential duplicate records in a CAS table?
- A . cas.duplicate
- B . cas.identify
- C . cas.verify
- D . cas.check
Which CAS action is used to compute derived variables or transformations on variables in a CAS table?
- A . cas.transform
- B . cas.compute
- C . cas.modify
- D . cas.derive