Question 1

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?

Options :

A : proc cas; table.save / table=work.sales_data caslib=mydata name="SalesDataPermanent"; run;

B : table.save / source=work.sales_data target=mydata.SalesDataPermanent; run;

C : saveTable / from=work.sales_data to=mydata.SalesDataPermanent; quit;

D : data mydata.SalesDataPermanent; set work.sales_data; run; quit;

Answer: A

Question 2

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?

Options :

A : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

B : datastep.runCode / code="data newTable; set oldTable; if Sales then if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

C : datastep.runCode / code="proc newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; end;";

D : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then do; Sales_Level = 'High'; end; else do; Sales_Level = 'Low'; end; run;";

Answer: A

Question 3

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?

Options :

A : data new_dataset; set old_dataset; num_income = input(char_income, 8.); run;

B : data new_dataset; set old_dataset; num_income = input(char_income, comma8.); run;

C : data new_dataset; set old_dataset; num_income = char_income * 1; run;

D : data new_dataset; set old_dataset; num_income = put(char_income, 8.); run;

Answer: A

Question 4

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?

Options :

A : COMMAw.d

B : DOLLARw.d

C : NUMERICw.d

D : DOLLARw.

Answer: A

Question 5

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

Options :

A : double

B : varchar

C : int64

D : numeric

Answer: B

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: