SAS Institute A00-415 SAS Viya Fundamentals of Programming Online Training

SAS Institute A00-415 Online Training

The questions for A00-415 were last updated at Feb 10,2025.

Exam Code: A00-415
Exam Name: SAS Viya Fundamentals of Programming
Certification Provider: SAS Institute
Latest update: Feb 10,2025

Question #61

Which CAS action is used to calculate the standard deviation, variance, and range for numeric variables in a CAS table?

A . cas.stddev
B . cas.variance
C . cas.range
D . cas.statistics

Question #62

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"}};

Reveal Solution Hide Solution

Question #63

Which function is used to calculate the mean of a variable in SAS Viya?

A . AVG
B . MEAN
C . SUM
D . MEDIAN

Reveal Solution Hide Solution

Question #64

Assume all caslib names follow libref naming conventions.

Which code assigns librefs of the same name to each caslib?

A . caslib _all_ assign;
B . caslib assign _all_;
C . caslib libref assign;
D . caslib assign libref;

Reveal Solution Hide Solution

Question #65

Which CAS-enabled procedure is used for descriptive statistics and data summarization?

A . PROC MEANS
B . PROC SQL
C . PROC FREQ
D . PROC GLM

Reveal Solution Hide Solution

Question #66

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;

Reveal Solution Hide Solution

Question #67

In SAS Viya, what is the purpose of the LIBNAME statement?

A . To create a new library
B . To import external data
C . To assign a library reference
D . To delete a library

Reveal Solution Hide Solution

Question #68

Which program will display ODS output?

A . proc cas;
print casuser.class;
quit;
B . proc cas;
simple.summary /
table={caslib="casuser" name="class"};
quit;
C . proc mdsummary data=casuser.class;
var height;
output out=casuser.result;
run;
D . proc cas;
table.fetch result=r /
table={caslib="casuser" name="class"};
quit;