Free Practice SAS Institute A00-420 Exam Questions 2025

An analyst is using fedSQL to write a query that requires case-sensitive string comparison between two columns, 'user_name' from the 'user_accounts' table and 'login' from the 'login_attempts' table. Given that the database is case-insensitive by default, which of the following code snippets would correctly perform a case-sensitive comparison?

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?

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?

When defining a variable in a CAS table using PROC CAS, which of the following data types requires specifying the maximum length attribute?

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?