Question 1

A data analyst needs to run a data manipulation task that involves sorting a table by multiple columns, then creating a new column based on a conditional statement. Which of the following sets of actions should be used in the given scenario when programming in SAS Viya?

Options :

A : table.loadTable followed by table.sortTable and then table.addTable

B : table.loadTable followed by table.sort and then column.addDerivedColumn

C : table.fetch followed by column.sort and then column.addCondition

D : fedSql.execDirect for the entire manipulation in a single step

Answer: B

Question 2

You are analyzing a dataset 'customer_data' using SAS Viya, where you have a categorical variable 'purchase_category' that represents the category of items each customer has purchased. You want to determine the distribution of customers across different purchase categories using the freq action in SAS Viya. Which of the following code snippets correctly achieves this?

Options :

A : proc freq data=customer_data; tables purchase_category; run;

B : proc means data=customer_data; class purchase_category; run;

C : proc cas; freq / table=customer_data var="purchase_category"; run;

D : data customer_data; set freq; by purchase_category; run;

Answer: C

Question 3

You have been tasked with ensuring that a particular numeric format is available for use in a CAS session. This format is required to display currency values in the format `$#,##0.00;($#,##0.00)`. Assuming the format has already been created and stored appropriately in CAS, where should you verify its existence before applying it to your analysis?

Options :

A : In the active environment session temporary files

B : In the in-memory tables loaded into the CAS session

C : In the user-specific profile settings within CAS

D : In the formats catalog in the caslib where the format was stored

Answer: D

Question 4

A data scientist wants to create a new variable in a dataset 'monthly_sales' that classifies each observation as "High", "Medium", or "Low" based on the value of 'total_sales'. Which function should be used to accomplish this?

Options :

A : The `IFN()` function

B : The `FLOOR()` function

C : The `CATEGORIZE()` function

D : The `CHOOSE()` function

Answer: A

Question 5

When a user attempts to view the contents of a caslib using PROC CASUTIL, they only want to see tables that contain the word "sales" in their name. Which of the following PROC CASUTIL statements would correctly perform this operation while utilizing the most efficient use of resources?

Options :

A : proc casutil; listtables caslib='default' where(name like '%sales%'); run;

B : proc casutil; listtables caslib='default'; run; where name contains 'sales';

C : proc casutil; listtables caslib='default'; run; title 'Tables with sales';

D : proc casutil; listtables caslib='default'; run;

Answer: A

Free A00-415 Mock Exam – Practice Online Confidently

Buying Options: