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;
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;
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?