SASInstitute SAS Viya Intermediate Programming - A00-420 Exam Practice Test
Which CAS-enabled procedure is used to fit regression models?
Correct Answer: A
When submitted, this program runs normally on the Compute Server and produces a cross-tab report:
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol norow nopercent;
run;
Correct Answer: B
What is the file extension used for SAS Viya programs?
Correct Answer: A
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;
Correct Answer: B
Which statement is true about SAS Viya?
Correct Answer: D
Which statement is used to read data from an external file into a SAS dataset?
Correct Answer: A
Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?
Correct Answer: C
How can you rename a CAS table in CAS?
Correct Answer: D
Which CAS-enabled procedure is used to perform linear regression analysis on CAS tables?
Correct Answer: A
Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?
Correct Answer: D
Which CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?
Correct Answer: B
Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?
Correct Answer: B