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 13,2025.

Exam Code: A00-420
Exam Name: SAS Viya Intermediate Programming
Certification Provider: SAS Institute
Latest update: Feb 13,2025

Question #21

Which CAS-enabled procedure is used for regression analysis and modeling?

A . PROC MEANS
B . PROC SQL
C . PROC FREQ
D . PROC GLM

Reveal Solution Hide Solution

Question #22

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;

Reveal Solution Hide Solution

Question #23

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.’)

Reveal Solution Hide Solution

Question #24

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

Reveal Solution Hide Solution

Question #25

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;

Reveal Solution Hide Solution

Question #26

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

Reveal Solution Hide Solution

Question #27

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.

Reveal Solution Hide Solution

Question #28

Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?