SAS Institute A00-420 SAS Viya Intermediate Programming Online Training
SAS Institute A00-420 Online Training
The questions for A00-420 were last updated at Feb 10,2025.
- Exam Code: A00-420
- Exam Name: SAS Viya Intermediate Programming
- Certification Provider: SAS Institute
- Latest update: Feb 10,2025
Which DATA step feature is NOT supported in CAS?
- A . DO Loops
- B . GIT functions
- C . Arrays
- D . IF-THEN/ELSE statements
Which CAS action is used to import data into CAS?
- A . CASLIB
- B . LOAD
- C . EXPORT
- D . ALTER TABLE
Which CAS action is used to delete a CASLIB?
- A . CASLIB
- B . DROP TABLE
- C . EXPORT
- D . ALTER TABLE
In the space below, add 1 character to complete the syntax.
proc cas;
table.tableDetails Answer
aslib="casuser", name=employees";
quit;
Which SQL clause is used to join multiple CAS tables based on a common key variable?
- A . SELECT
- B . FROM
- C . JOIN
- D . GROUP BY
Which SQL clause is used to calculate summary statistics for variables in a CAS table?
- A . SELECT
- B . FROM
- C . GROUP BY
- D . HAVING
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC GLM
In the DATA step, which statement is used to conditionally execute code?
- A . IF-THEN statement
- B . MERGE statement
- C . SELECT statement
- D . PROC statement
Which CAS-enabled procedure is used to perform data exploration and summarization?
- A . CASUTIL
- B . CASDATA
- C . CASSTAT
- D . CASPROC
Which CAS action is used to calculate the mean, median, and quartiles for numeric variables in a CAS table?
- A . cas.summary
- B . cas.describe
- C . cas.quantiles
- D . cas.statistics