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
Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?
- A . cas.aggregate
- B . cas.groupby
- C . cas.summarize
- D . cas.collapse
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 CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?
- A . cas.frequency
- B . cas.distribution
- C . cas.histogram
- D . cas.tabulate
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC GLM
Which SQL clause is used to filter rows in a CAS table based on specified conditions?
- A . SELECT
- B . FROM
- C . WHERE
- D . GROUP BY
What is the purpose of the EXECUTE action in CAS language programming?
- A . To execute a series of CAS actions
- B . To execute a SQL query
- C . To execute a DATA step program
- D . To execute a macro program
Which CASL statement correctly saves a SAS data set keeping only the empid and hrdate variables?
- A . table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate",
table={caslib="casuser", name="emp",
keep={{name="empid"}, {name="hrdate"}}}; - B . table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate",
table={caslib="casuser", name="emp",
vars={{name="empid"}, {name="hrdate"}}}; - C . table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate",
table={caslib="casuser", name="emp",
vars={"empid", "hrdate"}}; - D . table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate",
table={caslib="casuser", name="emp",
keep={"empid", "hrdate"}};
Which CAS-enabled procedure allows the creation of user-defined formats?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC FORMAT
Which operator is used for assignment in SAS Viya?
- A . =
- B . ==
- C . :=
- D . EQ
What is the primary advantage of using CAS-enabled procedures in SAS?
- A . Faster processing of large datasets
- B . Better visualization capabilities
- C . Easier data preparation
- D . Enhanced modeling techniques