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

Question #51

Which CAS-enabled procedure is used for descriptive statistics and data summarization?

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

Reveal Solution Hide Solution

Question #52

Which statement will show all available caslibs in the log?

A . caslib listall;
B . caslib all list;
C . caslib list;
D . caslib _all_ list;

Reveal Solution Hide Solution

Question #53

Which CAS action is used to perform aggregations and summary statistics?

A . SUMMARY
B . AGGREGATE
C . DESCRIBE
D . SUMMARIZE

Reveal Solution Hide Solution

Question #54

The set parameter of the table.update CAS action requires a specific type of value.

Which type is correct?

A . an array of arrays
B . a dictionary of arrays
C . a dictionary of dictionaries
D . an array of dictionaries

Reveal Solution Hide Solution

Question #55

Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?

A . proc cas;
table.addCaslib /
name="sales",
path="/data/sales";
run;
B . proc cas;
table.addCaslib /
name="sales",
dataSource={srctype="path"},
path="sales";
run;
C . proc cas;
table.addCaslib /
name="/data/sales",
dataSource={srctype="path"};
run;
D . proc cas;
table.addCaslib,
name="/data/sales",
path="/data/sales";
run;

Reveal Solution Hide Solution

Question #56

What is the purpose of the SET statement in the DATA step?

A . To define the input data source
B . To create a new variable
C . To specify conditional logic
D . To apply formatting to variables

Reveal Solution Hide Solution

Question #57

Which statement can execute successfully using PROC FEDSQL?

A . create table work.age12 as
select Name, Height, Weight
   from casuser.class
   where age=12
;
B . select Species, SepalWidth, SepalLength
   from casuser.iris
   where Species ^= "Setosa"
;
C . select HouseID, Brand, exp(logPrice) as Price
   from casuser.margarin
   where calculated Price > 5
;
D . create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
   from casuser.heart
   where cholesterol is null
;

Reveal Solution Hide Solution

Question #58

In PROC CASUTIL, what does the LOAD FILE= statement do?

A . It loads files from a file path on the CAS server to a CAS table.
B . It loads a file from a file location on the Compute Server to the CAS controller file system.
C . It loads a file from a file path on the Compute Server to a CAS table.
D . It loads the data from a CAS table to a file on the Compute Server.

Reveal Solution Hide Solution

Question #59

The table casuser.employees is partitioned onto 3 CAS worker nodes.

Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?

A)