Question 1

You have a CAS table named "sales_data" and you want to use the ALTERTABLE CASDATA statement in SAS Viya to change the data type of the column "total_sales" from varchar to double. Assuming the column "total_sales" exists and originally contains character data representing numeric values, which of the following statements would correctly alter the column data type?

Options :

A : ALTER TABLE CASDATA.sales_data MODIFY COLUMN total_sales SET TYPE double;

B : ALTER TABLE CASDATA.sales_data ALTER COLUMN total_sales TYPE double;

C : ALTER TABLE CASDATA.sales_data CHANGE COLUMN total_sales total_sales double;

D : ALTER TABLE CASDATA.sales_data MODIFY total_sales TYPE TO double;

Answer: B

Question 2

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 3

Which of the following is a true statement regarding variable scope in CASL?

Options :

A : Global variables declared outside of any function or action block are accessible only within the same script and cannot be accessed by other scripts or sessions.

B : CASL does not support local variables; all variables are global and can be accessed from any part of the program.

C : Variables in CASL are dynamically typed, and their scope is determined at runtime based on the execution context.

D : Local variables in CASL can be accessed and modified by any other blocks of code within the same action set.

Answer: A

Question 4

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 5

When using the dataStep action set in SAS Viya, you need to create a new table that includes a calculated column based on conditional processing of other columns in the data. Which of the following OPTIONS correctly demonstrates how to create a new variable that assigns a value of 'High' if the variable 'Sales' is above 1000 and 'Low' if 'Sales' is 1000 or below using the dataStep.runCode action?

Options :

A : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

B : datastep.runCode / code="data newTable; set oldTable; if Sales then if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

C : datastep.runCode / code="proc newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; end;";

D : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then do; Sales_Level = 'High'; end; else do; Sales_Level = 'Low'; end; run;";

Answer: A