A00-420 무료 덤프문제 온라인 액세스

How can you associate a user-defined format with a variable in SAS?

• A.Using the BY statement in PROC FORMAT
• B.Using the WHERE statement in PROC SQL
• C.Using the FORMAT statement in the DATA step
• D.Using the LABEL statement in PROC FORMAT

Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?

• A.cas.join
• B.cas.merge
• C.cas.combine
• D.cas.concat

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;

• A.The program runs normally on the Compute Server and produces a cross-tab report.
• B.The program produces an error indicating the DESCENDING option is not supported in the BY statement.
• C.The program produces an error indicating the NOPERCENT option is not supported in the TABLE statement.
• D.The program runs normally on the CAS server and produces a cross-tab report.

Select the correct way to define formats and labels in a FedSQL CREATE TABLE statement.

• A.Customer_Name char(35) having format $35. label 'Customer Name'
• B.Customer_Name char(35) format=$35. label='Customer Name'
• C.Customer_Name char(35) having format $35. label "Customer Name"
• D.Customer_Name char(35) format=$35. label="Customer Name"

Which function is used to calculate the mean of a variable in SAS Viya?

• A.SUM
• B.MEDIAN
• C.AVG
• D.MEAN