Absolute Free A00-420 Exam Practice for Comprehensive Preparation 

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?

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?

You have a dataset that includes a character column named 'char_income' which contains numeric values formatted as strings, such as "34500", "29800", etc. You need to convert this to a numeric column 'num_income' to perform calculations. Which code snippet would correctly perform this conversion?

Assume that you are working with a large dataset in CAS, and you have a need to create a flag variable that indicates whether certain criteria are met. This flag is based on a calculation that you do not want to repeat in multiple places throughout your DATA step code. How can the `computedVarsProgram=` parameter be utilized to optimize performance and maintainability?