Question 1

A programmer wants to create a new variable that increments by 1 each time a new group, defined by the BY statement, is encountered in the dataset. Which SAS programming technique can achieve this?

Options :

A : Utilize the FIRST. variable that is automatically created when using a BY statement to increase a counter variable when FIRST.variable is true.

B : Use a RETAIN statement to carry the value of the counter variable from one group to the next, resetting it to 1 whenever the BY group changes.

C : Implement a WHERE statement to filter the dataset according to the BY group and then accumulate the counter for each group separately.

D : Apply the SUM statement with the BY variable to increment the counter without using FIRST. or RETAIN statements.

Answer: A

Question 2

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 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

A SAS programmer wants to delete certain observations from a data set 'sales' where the 'product_code' is '1234'. The data set is indexed by 'product_code'. Which combination of statements is the most efficient way to accomplish this task?

Options :

A : MODIFY sales; WHERE product_code = '1234'; REMOVE;

B : MODIFY sales; IF product_code = '1234'; DELETE;

C : REPLACE sales; IF product_code = '1234'; DELETE;

D : MODIFY sales BY product_code; IF product_code = '1234'; REMOVE;

Answer: B

Question 5

When working in a SAS Viya environment, a programmer intends to save a series of informats and formats so that they are shared across various sessions and persisted beyond the current session. They specify the CASFMTLIB= option in their PROC FORMAT code. Which of the following is a result of executing this code with the CASFMTLIB= option set?

Options :

A : The informats and formats are saved to the specified caslib and can be shared across sessions, but they are not persistent after the session ends.

B : The new informats and formats are only available to the current session and must be recreated in subsequent sessions.

C : The informats and formats are saved to the specified caslib and are persistent, meaning they are available to subsequent sessions without needing to be recreated.

D : The CAS session is terminated, and all informats and formats are saved to sashelp library.

Answer: C

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: