SAS Institute A00-415 Practice Exams
Last updated on Oct 22,2026- Exam Code: A00-415
- Exam Name: SAS Viya Fundamentals of Programming
- Certification Provider: SAS Institute
- Latest update: Oct 22,2026
Question #151
Which CAS action is used to filter rows in a CAS table based on specified conditions?
- A . cas.select
- B . cas.filter
- C . cas.where
- D . cas.subset
Correct Answer: C
Question #152
Which CAS action is used to rename variables in a CAS table?
- A . cas.rename
- B . cas.modify
- C . cas.alter
- D . cas.change
Correct Answer: A
Question #153
Which statement is used to sort a SAS dataset in ascending order?
- A . SORT DESCENDING
- B . PROC SORT
- C . ORDER BY
- D . SORT DSN
Correct Answer: B
Question #154
Which CAS action is used to join multiple tables in SQL programming?
- A . MERGE
- B . JOIN
- C . UNION
- D . CONCATENATE
Correct Answer: B
Question #155
Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?
- A . cas.count
- B . cas.unique
- C . cas.missing
- D . cas.summary
Correct Answer: A
Question #156
What is the purpose of the GROUP BY clause in SQL programming?
- A . To sort the result set
- B . To filter rows based on conditions
- C . To define the output columns
- D . To group rows based on common values
Correct Answer: D
Question #157
Which SQL clause is used to sort rows in a CAS table based on specified variables?
- A . SELECT
- B . FROM
- C . ORDER BY
- D . GROUP BY
Correct Answer: C
Question #158
Which CAS action is used to retrieve a subset of rows and columns from a CAS table?
- A . cas.fetch
- B . cas.sample
- C . cas.filter
- D . cas.select
Correct Answer: A
Question #159
In which situation is it best to leverage the CAS server?
- A . When you need to use the LASR procedure to access data.
- B . When executing BY statements with high cardinality variables.
- C . When using large data and computationally complex code.
- D . When you need to SORT all of your data before processing.
Correct Answer: C
Question #160
Which statement can execute successfully using PROC FEDSQL?
- A . create table work.age12 as
select Name, Height, Weight
from casuser.class
where age=12
; - B . select Species, SepalWidth, SepalLength
from casuser.iris
where Species ^= "Setosa"
; - C . select HouseID, Brand, exp(logPrice) as Price
from casuser.margarin
where calculated Price > 5
; - D . create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
from casuser.heart
where cholesterol is null
;
Correct Answer: D