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

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;

In SAS Viya, what is the purpose of the LIBNAME statement?

• A.To assign a library reference
• B.To delete a library
• C.To import external data
• D.To create a new library

Which CAS action is used to execute a DATA step program in SAS CAS?

• A.SUBMIT
• B.RUN
• C.EXECUTE
• D.DATA

Which program will display ODS output?

• A.proc cas;
  table.fetch result=r / table={caslib="casuser" name="class"};
  quit;
• B.proc cas;
  print casuser.class;
  quit;
• C.proc cas;
  simple.summary / table={caslib="casuser" name="class"};
  quit;
• D.proc mdsummary data=casuser.class;
  var height;
  output out=casuser.result;
  run;

What is the purpose of the GROUP BY clause in SQL programming?

• A.To filter rows based on conditions
• B.To group rows based on common values
• C.To define the output columns
• D.To sort the result set