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

Consider the following SAS code which intends to retrieve values from an array to calculate the average sales for the first quarter: `

data work.quarterly_sales;

array qtr_sales[3];

do i=1 to 3;

set sales_data(keep=jan feb mar);

qtr_sales[i] = sales_data{i};

end;

avg_sales = mean(of qtr_sales[*]);

run;

The dataset `sales_data` has three variables named `jan`, `feb`, and `mar`, containing the sales for each month of the first quarter. Which statement is true regarding this code?

Options :

A : The code will correctly calculate `avg_sales` as the average of the first quarter sales.

B : The `set` statement is incorrectly placed inside the loop, causing an error.

C : The mean function is not used correctly and will result in an error.

D : The array subscript cannot use `sales_data{i}`, it should be `qtr_sales[i] = sales_data[i];`.

Answer: B

Question 3

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

Options :

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 4

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?

Options :

A : `proc means data=work.RunData mean std; var Time Distance Speed; run;`

B : `proc means data=work.RunData mean std; var Speed Distance Time; run;`

C : `proc means data=work.RunData; var Time Speed; run;`

D : `proc means data=work.RunData; run;`

Answer: A

Question 5

You are working on a project where multiple in-memory tables have been created during a CAS session using SAS Viya. As part of memory management, you've been asked to remove a specific table, 'sales_data', from memory. Which of the following code snippets correctly uses the table.dropTable action to accomplish this task?

Options :

A : cas.table.dropTable(caslib='casuser', name='sales_data')

B : proc cas; table.dropTable / caslib='casuser' name='sales_data'; quit;

C : table.dropTable / table='casuser.sales_data';

D : dropTable 'casuser.sales_data';

Answer: B

Confidently Practice Online with Free A00-420 Exam Cram

Buying Options: