Online Access Free A00-420 Practice Test

Which CAS action is used to perform aggregations and summary statistics in the DATA step?

• A.SUMMARY
• B.FORMAT
• C.GROUP BY
• D.COMPUTE

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%')

Which SAS function is used to concatenate character variables?

• A.CATS
• B.CAT
• C.LENGTH
• D.CONCAT

What is the purpose of the BY statement in CAS language programming?

• A.To specify the output format
• B.To merge multiple tables
• C.To subset the data
• D.To group data by one or more variables

Which CAS action is used to import data into CAS?

• A.EXPORT
• B.CASLIB
• C.ALTER TABLE
• D.LOAD