Question 1

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 2

What is the correct way to use the CAS library to save the results of a procedure in SAS Viya?

Options :

A : Use a DATA step with the CASLIB statement to specify the target CAS library where the results should be saved.

B : Use the PROC COPY command with the TO= and FROM= options to move result tables to a specified CAS library.

C : Assign a libref to the desired CAS library and then specify that libref in the OUT= option of the procedure.

D : Result tables are automatically saved to the CAS library assigned to the user at login and no additional steps are required.

Answer: C

Question 3

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 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

You are given a raw data file with a variable that contains currency amounts, including a dollar sign, commas, and decimal points (e.g., "$1,234.56"). You need to create a new SAS dataset and ensure that these amounts are read as numeric values without the currency formatting. Which informat would appropriately read the variable as a numeric value?

Options :

A : COMMAw.d

B : DOLLARw.d

C : NUMERICw.d

D : DOLLARw.

Answer: A

Higher Test Marks with Free Online A00-420 Exam Practice

Buying Options: