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 for regression analysis and modeling?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC GLM
Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?
- A . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv" replace;
quit; - B . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv";
quit; - C . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees";
quit; - D . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees" replace;
quit;
Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as
markup_N
from casuser.cars";
run;
- A . put(markup,’best12.’)
- B . inputn(markup,’best12.’)
- C . cast(markup,’best12.’)
- D . input(markup,’best12.’)
In SAS Viya, what is the purpose of the LIBNAME statement?
- A . To create a new library
- B . To import external data
- C . To assign a library reference
- D . To delete a library
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?
- A . caslib mycas path="/workshop/data" global;
- B . caslib path="/workshop/data" mycas global;
- C . caslib path="/workshop/data" mycas promote;
- D . caslib mycas path="/workshop/data" promote;
The dataPreprocess.impute action preforms data matrix (variable) imputation.
Which imputation methods can be used?
- A . MIDRANGE, MODE, RANDOM, VALUE
- B . MIDRANGE, MODE, RANDOM, CUSTOM
- C . MODE, RANDOM, VALUE, CUSTOM
- D . MIDRANGE, RANDOM, VALUE, CUSTOM
Which statement is true about SAS Viya?
- A . It contains the SAS launcher server, which is the primary server for processing big data.
- B . It supports only single-threaded DATA step processing.
- C . It can employ multiple servers to execute programs.
- D . Its primary interface for submitting programs is the SAS Windowing Environment.
Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?
- A . cas.join
- B . cas.concat
- C . cas.combine
- D . cas.merge
Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?
- A . MAXDATA=
- B . CASDATALIMIT=
- C . NOCOMPUTE
- D . MAXOBS=
Which SQL clause is used to filter rows in a CAS table based on specified conditions?
- A . SELECT
- B . FROM
- C . WHERE
- D . GROUP BY