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 CAS-enabled procedure is used to apply user-defined formats to variables?
- A . CASUTIL
- B . CASTABULATE
- C . CASFORMAT
- D . CASPROC
Which SAS Viya procedure is used for statistical modeling and regression analysis?
- A . PROC GLM
- B . PROC MEANS
- C . PROC FREQ
- D . PROC SQL
Which statement about the CASL language is true?
- A . All CAS-enabled procedures are converted to CASL behind the scenes to run in CAS.
- B . CASL runs actions on both the SAS Compute Server and in CAS.
- C . Actions in CASL are grouped into PROCs, and optional information is provided with parameters.
- D . CASL code is submitted to the CAS server using PROC CASUTIL.
Which PROC MDSUMMARY step produces results?
- A . proc mdsummary data=casuser.orders;
var profit;
output out=casuser.sumorders;
run; - B . proc mdsummary data=casuser.orders;
var profit;
out casuser.sumorders;
run; - C . proc mdsummary data=casuser.orders;
var profit /
out=casuser.sumorders;
run; - D . proc mdsummary data=casuser.orders;
var profit;
run;
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 CAS action is used to validate the integrity of relationships between variables in a CAS table?
- A . cas.integrity
- B . cas.relationship
- C . cas.validate
- D . cas.link
How can you view the contents of a CAS table?
- A . Using the CASLIB action
- B . Using the LOAD action
- C . Using the FETCH action
- D . Using the TABLE action
Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.
proc mdsummary data=casuser.orders;
var cost;
groupby continent /_______;
run;
What is the purpose of the SAS Explorer in SAS Studio?
- A . To manage and organize SAS files and folders
- B . To visualize data in graphical format
- C . To write and execute SAS programs
- D . To perform data cleaning and transformation
Which statement is true about the Compute Server?
- A . It processes programs written in SAS, Python, Java, and other open source client languages.
- B . It generally outperforms the CAS server for data sources that are larger than 50 Gigabytes.
- C . It processes distributed data in multiple threads.
- D . It supports the creation and execution of Macro programs.