Question 1

When setting up a data step in a SAS Viya environment, your code needs to read a database table hosted on a remote server, which is registered as a library in SAS Viya's library manager. What would be the appropriate LIBNAME statement to ensure that your data step can access this table?

Options :

A : libname mylib base 'server_path_to_data';

B : libname mylib meta LIBRARY="RemoteServerLib";

C : libname mylib sasiohttp HOSTNAME="remoteserver.com";

D : libname mylib v9 'server_path_to_data';

Answer: B

Question 2

Assume that you are working with a large dataset in CAS, and you have a need to create a flag variable that indicates whether certain criteria are met. This flag is based on a calculation that you do not want to repeat in multiple places throughout your DATA step code. How can the `computedVarsProgram=` parameter be utilized to optimize performance and maintainability?

Options :

A : Use the `computedVarsProgram=` parameter to define the flag calculation and reference the flag variable later in the DATA step without redefining the calculation.

B : Set the `computedVarsProgram=` parameter to create a macro variable with the desired flag value so it can be used throughout the DATA step.

C : Apply the `computedVarsProgram=` parameter in multiple DATA steps so each one can perform the flag calculation independently.

D : Invoke the `computedVarsProgram=` parameter at the end of the DATA step to store the results of the flag calculation for subsequent steps.

Answer: A

Question 3

You are working on a project with a dataset named `sales` in the SAS Viya environment. You have been tasked to create a new dataset `luxury_sales` that includes records of luxury items with a price greater than $10,000. You decide to use the `WHERE=` subparameter in your code to filter the dataset. What is the correct way to apply the `WHERE=` subparameter to achieve this?

Options :

A : PROC COPY DATA=sales OUT=luxury_sales WHERE=(price > 10000);

B : DATA luxury_sales; SET sales (WHERE=(price > 10000)); RUN;

C : PROC SORT DATA=sales; BY price; WHERE price > 10000; OUTPUT OUT=luxury_sales; RUN;

D : PROC SQL; CREATE TABLE luxury_sales AS SELECT * FROM sales WHERE price > 10000; RUN;

Answer: B

Question 4

You have a dataset that includes a character column named 'char_income' which contains numeric values formatted as strings, such as "34500", "29800", etc. You need to convert this to a numeric column 'num_income' to perform calculations. Which code snippet would correctly perform this conversion?

Options :

A : data new_dataset; set old_dataset; num_income = input(char_income, 8.); run;

B : data new_dataset; set old_dataset; num_income = input(char_income, comma8.); run;

C : data new_dataset; set old_dataset; num_income = char_income * 1; run;

D : data new_dataset; set old_dataset; num_income = put(char_income, 8.); run;

Answer: A

Question 5

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