A00-420

Which CAS-enabled procedure is used for data exploration and visualization?A . PROC MEANSB . PROC SQLC . PROC FREQD . PROC SGPLOTView AnswerAnswer: D

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...

Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?A . cas.summarizeB . cas.profileC . cas.statisticsD . cas.inspectView AnswerAnswer: B

Which DATA step feature is NOT supported in CAS?A . DO LoopsB . GIT functionsC . ArraysD . IF-THEN/ELSE statementsView AnswerAnswer: B

Which CAS action is used to execute SQL queries in SAS CAS?A . SQLB . RUNC . SUBMITD . EXECUTEView AnswerAnswer: A

Which operator is used for assignment in SAS Viya?A . =B . ==C . :=D . EQView AnswerAnswer: C

Which statement is used to sort a SAS dataset in ascending order?A . SORT DESCENDINGB . PROC SORTC . ORDER BYD . SORT DSNView AnswerAnswer: B

Which CAS action is used to create a new CAS table based on specified conditions?A . FILTERB . SELECTC . WHERED . SUBSETView AnswerAnswer: C

Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?A . cas.countB . cas.uniqueC . cas.missingD . cas.summaryView AnswerAnswer: 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;A . put(markup,'best12.')B . inputn(markup,'best12.')C . cast(markup,'best12.')D . input(markup,'best12.')View AnswerAnswer: B