Free Online SAS Institute A00-420 Practice Test

When performing a data manipulation task using the simple action set in SAS Viya, you need to group the data by the 'region' variable and then calculate the total sales for each region. Which action should you use to accomplish this task within the simple action set?

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?

You have created a data table 'work.sales_data' using SAS procedures and want to use the 'table.save' method to store this data table permanently in the 'mydata' library. Which of the following code snippets correctly accomplishes this task, assuming that the 'mydata' library has already been assigned?

A programmer wants to utilize the `TABULATE` procedure in SAS Viya for generating a summary report. They need to limit the output to only include the observations for which the 'type' variable equals 'Residential'. Which option demonstrates the correct use of the `WHERE=` parameter in PROC TABULATE to accomplish this task?

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?