Question 1

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

Question 2

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

Options :

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 3

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 4

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 5

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

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: