Try our Free Demo Practice Tests for Comprehensive A00-420 Exam Preparation

You have loaded a data set into a CAS session and need to perform a simple aggregation that summarizes total sales by region. Which of the following CAS actions allows you to do this most efficiently?

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?

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?

A data analyst is using the fedSQL action set to combine data from separate tables stored in a distributed environment. They want to perform a left join on two tables, 'customers' and 'orders', based on the customer ID. Which of the following fedSQL statements accomplishes this?

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?