A00-420

The dataPreprocess.impute action preforms data matrix (variable) imputation. Which imputation methods can be used?A . MIDRANGE, MODE, RANDOM, VALUEB . MIDRANGE, MODE, RANDOM, CUSTOMC . MODE, RANDOM, VALUE, CUSTOMD . MIDRANGE, RANDOM, VALUE, CUSTOMView AnswerAnswer: A

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;A . resultTable.where(column like 'MPG%')B . resultTable.where("column like 'MPG%'")C . resultTable / where("column like 'MPG%'")D . resultTable / where(column like 'MPG%')View AnswerAnswer: A

What is the purpose of the BY statement in the DATA step?A . To sort the dataB . To subset the dataC . To rename variablesD . To merge datasetsView AnswerAnswer: A

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;View AnswerAnswer: casuser.cost_cont

Which SQL clause is used to join multiple CAS tables based on a common key variable?A . SELECTB . FROMC . JOIND . GROUP BYView AnswerAnswer: C

Which statement about the CASL language is true?A . All CAS-enabled procedures are converted to CASL behind the scenes to run in CAS.B . CASL runs actions on both the SAS Compute Server and in CAS.C . Actions in CASL are grouped into PROCs, and optional information is provided with...

Which CAS action is used to validate the integrity of relationships between variables in a CAS table?A . cas.integrityB . cas.relationshipC . cas.validateD . cas.linkView AnswerAnswer: B

Which SAS Viya component is responsible for storing and managing user-defined formats?A . CAS serverB . SAS StudioC . SAS Metadata ServerD . SAS Data ConnectorView AnswerAnswer: C

If a dictionary named res contains a table named fetch, which statement will print the table?A . if res="fetch" then print res.fetch;B . if res contains "fetch" then print res.fetch;C . if dim(res, "fetch") > 0 then print res.fetch;D . if exists(res, "fetch") then print res.fetch;View AnswerAnswer: D

Which programming language is used in the DATA step of SAS CAS?A . SASB . SQLC . RD . PythonView AnswerAnswer: A