A00-420 Exam Question 1

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;

A00-420 Exam Question 2

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;
  • A00-420 Exam Question 3

    Which CAS statement is used to select specific columns from a CAS table?
  • A00-420 Exam Question 4

    Which CAS action is used to rename variables in a CAS table?
  • A00-420 Exam Question 5

    Which SAS Viya component is responsible for storing and managing user-defined formats?