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 Nov 22,2024.

Exam Code: A00-420
Exam Name: SAS Viya Intermediate Programming
Certification Provider: SAS Institute
Latest update: Nov 22,2024

Question #11

The regnm format has been created and stored in an CAS format library.

Which program associates the format regnm with the region column in the orders table?

A . proc casutil;
load data=work.orders casout="orders" outcaslib="public";
format region regnm.;
quit;
B . proc casutil;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
format region regnm.;
quit;
C . proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
quit;
D . proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public";
quit;

Reveal Solution Hide Solution

Question #12

Which CAS-enabled procedure is used to combine multiple CAS tables based on a common key variable?

A . CASMERGE
B . CASCOMBINE
C . CASTABLE
D . CASEJOIN

Reveal Solution Hide Solution

Question #13

Which variables must be included in the CAS table that stores DATA step code to be executed by the dataStep.runCodeTable action?

A . PgmName
CASEngine
B . Code
TableName
C . Source
Name
D . DataStepSrc
ModelName
E . DataStepSrc
ModelName

Reveal Solution Hide Solution

Question #14

Which CAS action is used to create a new CAS table based on specified conditions?

A . FILTER
B . SELECT
C . WHERE
D . SUBSET

Reveal Solution Hide Solution

Question #15

Which DATA step will NOT run in CAS?

A . data casuser.class;
  input x;
  datalines;
1
2
3
;
run;
B . data casuser.new;
  x=1;
run;
C . data casuser.new;
  set casuser.class;
  x=((height*weight)+10)/(age**2)+round(100.9999);
run;
D . data casuser.new;
  array test(*) weight height age (1 2 3);
  do i=1 to dim(test);
    put test(i)=;
  end;
run;

Reveal Solution Hide Solution

Question #16

What is the purpose of the LIBNAME statement in SAS Viya?

A . Defining a library or a location for SAS datasets
B . Declaring and initializing variables
C . Executing SQL queries
D . Controlling the flow of the program

Reveal Solution Hide Solution

Question #17

Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

A . Option A
B . Option B
C . Option C
D . Option D

Reveal Solution Hide Solution

Question #18

Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?

A . sashdat
B . sas7bdat
C . csv
D . txt

Reveal Solution Hide Solution

Question #19

In the following code, complete the PRINT statement to print only rows where column begins with MPG:

proc cas;

simple.summary result=res /

table={name="cars"};

resultTable = res.summary;

print <insert code segment

here>;

run;