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 #141
Which CAS action is used to remove duplicate records from a CAS table?
- A . cas.distinct
- B . cas.unique
- C . cas.dedup
- D . cas.remove
Correct Answer: C
Question #142
Which statement about CASL is true?
- A . CASL is a replacement for the DATA Step.
- B . CASL allows you to run any CAS action.
- C . CASL is an open source language.
- D . CASL is a replacement for SQL.
Correct Answer: B
Question #143
In SQL programming, which statement is used to filter rows based on conditions?
- A . SELECT
- B . WHERE
- C . HAVING
- D . ORDER BY
Correct Answer: B
Question #144
Which SAS procedure is used for generating descriptive statistics?
- A . PROC SUMMARY
- B . PROC REPORT
- C . PROC MEANS
- D . PROC TABULATE
Correct Answer: C
Question #145
DATA step performance in CAS is most affected:
- A . when the NOTSORTED option is used in the BY statement.
- B . when the DESCENDING option is used in the BY statement.
- C . by the cardinality of the first variable listed in the BY statement.
- D . when data is not sorted prior to using a BY statement.
Correct Answer: C
Question #146
What is a user-defined format in SAS?
- A . A format that is created and stored by the user
- B . A format that is predefined by SAS
- C . A format that is specific to CAS-enabled procedures
- D . A format that is used for data visualization
Correct Answer: A
Question #147
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
Correct Answer: A
Question #148
Which statement will show all available caslibs in the log?
- A . caslib listall;
- B . caslib all list;
- C . caslib list;
- D . caslib _all_ list;
Correct Answer: D
Question #149
Which CASL program will fetch all 428 rows from the cars table?
- A . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=1000;
quit; - B . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_all_;
quit; - C . . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_maxrows_;
quit; - D . proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1;
quit;
Correct Answer: A
Question #150
Which CAS action is used to select specific columns from a CAS table?
- A . SELECT
- B . PICK
- C . CHOOSE
- D . EXTRACT
Correct Answer: A