SAS Institute A00-420 SAS Viya Intermediate Programming Online Training
SAS Institute A00-420 Online Training
The questions for A00-420 were last updated at Oct 15,2024.
- Exam Code: A00-420
- Exam Name: SAS Viya Intermediate Programming
- Certification Provider: SAS Institute
- Latest update: Oct 15,2024
Given the following SAS program:
data casuser.national;
set casuser.baseball(where=(league=’National’));
r=ranuni(625);
drop league;
run;
Why is the above program processed by the Compute Server rather than the CAS server?
- A . The WHERE option is not supported in the SET statement.
- B . The SESSREF= option is not specified in the DATA statement.
- C . The DROP statement is not supported.
- D . The RANUNI function is not supported.
Which CAS action is used to execute SQL queries in SAS CAS?
- A . SQL
- B . RUN
- C . SUBMIT
- D . EXECUTE
Which CAS statement is used to join two or more CAS tables based on a common key variable?
- A . CASMERGE
- B . CASTABLE
- C . CASJOIN
- D . CASCOMBINE
Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?
- A . cas.summarize
- B . cas.profile
- C . cas.statistics
- D . cas.inspect
The following code is executed multiple times:
data casuser.eurorders;
set casuser.orders end=eof;
if Continent="Europe" then EurOrders+1;
if eof=1 then output;
keep EurOrders;
run;
proc print data=casuser.eurorders;
run;
Will the rows in the output table be sorted the same way for each execution and why?
- A . Yes, because only one row will be printed.
- B . Yes, because by default CAS sorts the output table.
- C . No, because each thread inserts a row into the casuser.eurorders table when it ends.
- D . No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.
Which SAS Viya component allows users to create and manage machine learning models?
- A . SAS Data Preparation
- B . SAS Studio
- C . SAS Visual Analytics
- D . SAS Model Studio
Which SAS Viya procedure is used for data summarization and descriptive statistics?
- A . PROC GLM
- B . PROC MEANS
- C . PROC FREQ
- D . PROC SQL
Which function is used to calculate the mean of a variable in SAS Viya?
- A . AVG
- B . MEAN
- C . SUM
- D . MEDIAN
Which DATA step statement is used to read data from an external file in CAS programming?
- A . PROC SQL
- B . SET statement
- C . MERGE statement
- D . OUTPUT statement
Which CAS action is used to calculate the correlation matrix for numeric variables in a CAS table?
- A . cas.correlation
- B . cas.covariance
- C . cas.relationship
- D . cas.association
Latest A00-420 Dumps Valid Version with 250 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
