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 Feb 16,2025.
- Exam Code: A00-420
- Exam Name: SAS Viya Intermediate Programming
- Certification Provider: SAS Institute
- Latest update: Feb 16,2025
Which table.update parameter specifies the column to update?
- A . Assign
- B . Update
- C . Set
- D . ComputedVars
Which CAS statement is used to load data from an external file into a CAS table?
- A . CASLIB
- B . CASTABLE
- C . CASIMPORT
- D . CASDATA
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;
Which action loads the cars.csv file from the casuser caslib into memory?
- A . table.loadTable / caslib="casuser" , path="cars.csv";
- B . table.loadTable / table={caslib="casuser", path="cars.csv"};
- C . table.upload / caslib="casuser" , path="cars.csv";
- D . table.upload / table={caslib="casuser", path="cars.csv"};
Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?
- A . caslib _all_ assign;
- B . caslib assign _all_;
- C . caslib libref assign;
- D . caslib assign libref;
What is the purpose of the CASLIB statement in SAS Viya?
- A . To create a new CASLIB
- B . To import external data into CAS
- C . To delete a CASLIB
- D . To assign a CASLIB reference
You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods.
What is the most efficient way to achieve this?
- A . Load the table into CAS memory and use a CAS procedure to summarize it.
- B . Summarize the data using a SAS in-database procedure.
- C . Create a SAS dataset copy of the table, load it into CAS memory and summarize with a CAS procedure.
- D . Read the table directly with a SAS summary procedure that executes on the Compute Server.
Which CAS action is used to create a new variable in a CAS table based on a conditional expression?
- A . cas.derive
- B . cas.calculate
- C . cas.transform
- D . cas.generate
When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?
- A . MIN
- B . MEAN
- C . SKEW
- D . STD
Which DATA step function is supported in CAS?
- A . SYMGET
- B . CATX
- C . FILEREF
- D . RANUNI
Latest A00-420 Dumps Valid Version with 250 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
