Question 1

When using SAS Viya, you want to perform a linear regression analysis on a dataset stored in the cloud. You decide to use an action from the 'regression' action set. Which of the following actions should you invoke to perform this task using a CAS session?

Options :

A : table.loadTable

B : simpleReg

C : regression.linear

D : fedSql.execDirect

Answer: C

Question 2

Consider the following SAS code which intends to retrieve values from an array to calculate the average sales for the first quarter: `

data work.quarterly_sales;

array qtr_sales[3];

do i=1 to 3;

set sales_data(keep=jan feb mar);

qtr_sales[i] = sales_data{i};

end;

avg_sales = mean(of qtr_sales[*]);

run;

The dataset `sales_data` has three variables named `jan`, `feb`, and `mar`, containing the sales for each month of the first quarter. Which statement is true regarding this code?

Options :

A : The code will correctly calculate `avg_sales` as the average of the first quarter sales.

B : The `set` statement is incorrectly placed inside the loop, causing an error.

C : The mean function is not used correctly and will result in an error.

D : The array subscript cannot use `sales_data{i}`, it should be `qtr_sales[i] = sales_data[i];`.

Answer: B

Question 3

A programmer wants to create a new variable that increments by 1 each time a new group, defined by the BY statement, is encountered in the dataset. Which SAS programming technique can achieve this?

Options :

A : Utilize the FIRST. variable that is automatically created when using a BY statement to increase a counter variable when FIRST.variable is true.

B : Use a RETAIN statement to carry the value of the counter variable from one group to the next, resetting it to 1 whenever the BY group changes.

C : Implement a WHERE statement to filter the dataset according to the BY group and then accumulate the counter for each group separately.

D : Apply the SUM statement with the BY variable to increment the counter without using FIRST. or RETAIN statements.

Answer: A

Question 4

You are working on a project where multiple in-memory tables have been created during a CAS session using SAS Viya. As part of memory management, you've been asked to remove a specific table, 'sales_data', from memory. Which of the following code snippets correctly uses the table.dropTable action to accomplish this task?

Options :

A : cas.table.dropTable(caslib='casuser', name='sales_data')

B : proc cas; table.dropTable / caslib='casuser' name='sales_data'; quit;

C : table.dropTable / table='casuser.sales_data';

D : dropTable 'casuser.sales_data';

Answer: B

Question 5

You are required to modify an existing table named "sales_data" by adding a new column titled "discount_amount" that will store numerical values representing the discount given for each sale. Which of the following ALTER TABLE statements would correctly add the required column?

Options :

A : ALTER TABLE sales_data ADD COLUMN discount_amount NUMERIC;

B : ALTER TABLE sales_data ADD discount_amount NUMERIC;

C : ALTER TABLE sales_data APPEND COLUMN discount_amount NUMERIC;

D : ALTER TABLE sales_data INCORPORATE discount_amount AS NUMERIC;

Answer: A