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
In the following code, complete the PRINT statement to print only rows where column begins with MPG:
proc cas;
simple.summary result=res /
table={name="cars"};
resultTable = res.summary;
print <insert code segment
here>;
run;
- A . resultTable.where(column like ‘MPG%’)
- B . resultTable.where("column like ‘MPG%’")
- C . resultTable / where("column like ‘MPG%’")
- D . resultTable / where(column like ‘MPG%’)
Which SAS Viya procedure is used for statistical modeling and regression analysis?
- A . PROC GLM
- B . PROC MEANS
- C . PROC FREQ
- D . PROC SQL
Which SAS Viya procedure is used for data summarization and descriptive statistics?
- A . PROC GLM
- B . PROC MEANS
- C . PROC FREQ
- D . PROC SQL
In PROC CASUTIL, what does the LOAD FILE= statement do?
- A . It loads files from a file path on the CAS server to a CAS table.
- B . It loads a file from a file location on the Compute Server to the CAS controller file system.
- C . It loads a file from a file path on the Compute Server to a CAS table.
- D . It loads the data from a CAS table to a file on the Compute Server.
Given the following SAS program:
proc mdsummary data=casuser.orders;
var RetailPrice;
output out=casuser.orders_sum;
run;
Which CAS action produces the same result as the code above without ERROR if you run it twice?
- A . proc cas;
simple.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’};
quit; - B . proc cas;
simple.mdsummary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’, replace=true};
quit; - C . proc cas;
simple.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’, replace=true};
quit; - D . proc cas;
md.summary /
table={name="orders", caslib="casuser"},
input={"RetailPrice"},
casOut={name=’orders_sum’};
quit;
Which CAS action is used to delete a CASLIB?
- A . CASLIB
- B . DROP TABLE
- C . EXPORT
- D . ALTER TABLE
What is the purpose of the APPEND action in CAS language programming?
- A . To add new observations to an existing CAS table
- B . To append columns to an existing CAS table
- C . To concatenate multiple CAS tables vertically
- D . To merge multiple CAS tables horizontally
What is the purpose of the LIBNAME statement in SAS Viya?
- A . Defining a library or a location for SAS datasets
- B . Declaring and initializing variables
- C . Executing SQL queries
- D . Controlling the flow of the program
Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.
proc mdsummary data=casuser.orders;
var cost;
groupby continent /_______;
run;
Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?
proc cas;
table.altertable /
caslib="casuser", name="cars",
<enter code
segment here>;
quit;
- A . columns={name="make" = "veh_make"};
- B . columns=[[name="make" , rename="veh_make"]];
- C . columns={{rename="make" , name="veh_make"}};
- D . columns={{name="make" , rename="veh_make"}};