Question 1

A data analyst is preparing a report using PROC REPORT in SAS Viya. The analyst needs to display customer details from the 'customers' table but wants only the 'CustomerID', 'FirstName', 'LastName', and 'Email' columns to be included in the report. Which TABLE statement below would correctly produce this output?

Options :

A : TABLE customers(CustomerID, FirstName, LastName, Email);

B : TABLE customers ALL COLUMNS;

C : TABLE customers(SELECT CustomerID, FirstName, LastName, Email FROM customers);

D : TABLE customers VAR CustomerID FirstName LastName Email;

Answer: A

Question 2

When working with the CAS (Cloud Analytic Services) using SAS Viya, you need to reference a custom data format that you previously created for a data analytics project. In which location within CAS would you likely store and access this custom format to ensure it can be applied to your datasets during your analysis sessions?

Options :

A : In the caslibs designated for user data

B : In the casuser personal folder

C : In the formats catalog within a specific caslib

D : In the CAS global environment settings

Answer: C

Question 3

When analyzing the time between customer purchases, a data analyst needs to extract the month from a date variable 'purchase_date' in the SAS Viya environment. Which function can be appropriately used to extract the month component from the date?

Options :

A : `DATEPART()`

B : `MONTH()`

C : `DAY()`

D : `EXTRACT()`

Answer: B

Question 4

You are designing a stored process in SAS Viya and you need to dynamically pass a table name into a SQL step. Which of the following SAS macro invocations would correctly supply a dataset name to the macro so that it can be used in the SQL step to reference a table parameter named 'myTable'?

Options :

A : %let tableName = 'work.myData'; %myMacro(table=tableName);

B : %let tableName = work.myData; %myMacro(table=tableName);

C : %let tableName = work.myData; %myMacro(table=&tableName;);

D : %let tableName = 'work.myData'; %myMacro(table=&tableName.;);

Answer: C

Question 5

When using the CASUSER caslib in a SAS Viya environment, which of the following statements is correct regarding data accessibility?

Options :

A : Data in the CASUSER caslib is private to each individual user and is deleted after the user-s session ends.

B : All users share the same CASUSER caslib, which allows for easy data sharing across the SAS Viya environment.

C : Data in the CASUSER caslib is replicated across all nodes in the CAS cluster to ensure high availability.

D : The CASUSER caslib is read-only, and users can only import data to other caslibs.

Answer: A