SAS Institute A00-415 Practice Exams
Last updated on Oct 21,2026- Exam Code: A00-415
- Exam Name: SAS Viya Fundamentals of Programming
- Certification Provider: SAS Institute
- Latest update: Oct 21,2026
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.
How can you associate a user-defined format with a variable in SAS?
- A . Using the FORMAT statement in the DATA step
- B . Using the WHERE statement in PROC SQL
- C . Using the BY statement in PROC FORMAT
- D . Using the LABEL statement in PROC FORMAT
What is the primary programming language used in SAS Viya?
- A . SAS
- B . R
- C . Python
- D . Java
Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as
markup_N
from casuser.cars";
run;
- A . put(markup,’best12.’)
- B . inputn(markup,’best12.’)
- C . cast(markup,’best12.’)
- D . input(markup,’best12.’)
Which CAS action is used to delete a CAS table from memory?
- A . cas.delete
- B . cas.remove
- C . cas.drop
- D . cas.discard
Which action from the table action set lists the files in a caslib’s data source?
- A . tableInfo
- B . fileInfo
- C . tableDetails
- D . caslibInfo
Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?
- A . sashdat
- B . sas7bdat
- C . csv
- D . txt
Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?
- A . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv" replace;
quit; - B . proc casutil;
save casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees.csv";
quit; - C . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees";
quit; - D . proc casutil;
save type="csv" casdata="employees" incaslib="casuser"
outcaslib="casuser" casout="out_employees" replace;
quit;
In order to use a user-defined format in CAS, which condition must be true?
- A . The format must be saved to the FORMATS caslib.
- B . The format must exist in a CAS format library.
- C . The format name must begin with the prefix ‘cas’.
- D . The system option CASFORMATS=True must be specified.
Which CAS action is used to merge two or more CAS tables based on a common key variable?
- A . cas.combine
- B . cas.append
- C . cas.union
- D . cas.merge