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

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?

A SAS Viya data analyst is tasked with selecting a random subset of data from a dataset called 'CustomerData', which contains over 1 million records. The requirement is to analyze a manageable subset without any bias. How should the analyst use the 'subSet=' parameter in a procedure to ensure a random selection?

In a multi-session SAS Viya environment, a data analyst needs to execute a DATA step that assigns a permanent library using the LIBNAME statement. The analyst needs to ensure that the dataset created within the DATA step is available in the assigned library for all subsequent sessions. Which DATA statement option should the analyst use to specify the session where the library and dataset will be accessible?

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?

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