Question 1

A SAS programmer wants to delete certain observations from a data set 'sales' where the 'product_code' is '1234'. The data set is indexed by 'product_code'. Which combination of statements is the most efficient way to accomplish this task?

Options :

A : MODIFY sales; WHERE product_code = '1234'; REMOVE;

B : MODIFY sales; IF product_code = '1234'; DELETE;

C : REPLACE sales; IF product_code = '1234'; DELETE;

D : MODIFY sales BY product_code; IF product_code = '1234'; REMOVE;

Answer: B

Question 2

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

Question 3

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 4

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 5

When using PROC MEANS to summarize data, a programmer needs to display only the variables "Time", "Distance", and "Speed" from a dataset, while also calculating the mean and standard deviation for those variables. Which of the following VAR statements is the most efficient way to achieve this while maintaining the original order in the dataset?

Options :

A : `proc means data=work.RunData mean std; var Time Distance Speed; run;`

B : `proc means data=work.RunData mean std; var Speed Distance Time; run;`

C : `proc means data=work.RunData; var Time Speed; run;`

D : `proc means data=work.RunData; run;`

Answer: A

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: