Question 1

A data analyst is creating a SAS Viya program that requires the user to input a date value at the beginning of the session, which will then be used to filter a dataset showing sales within a certain range. The date format expected is "YYYY-MM-DD". Which method allows the program to prompt the user for an input parameter and ensures the value is stored in a macro variable with the appropriate format for further use in the program?

Options :

A : %let sales_date = %sysget(YYYY-MM-DD);

B : %let sales_date = %str(YYYY-MM-DD);

C : %let sales_date = %sysfunc(inputn(&sysparm.;, yymmdd10.));

D : %let sales_date = %window('Enter sales date in format YYYY-MM-DD');

Answer: C

Question 2

You are working on a SAS Viya programming task that involves the manipulation of customer transaction data. You have a numeric variable named 'Trans_Amount', which stores the transaction amounts in dollars and cents (e.g., 123.45). However, you notice that some transaction amounts are incorrectly recorded as negative values due to a data entry error. To ensure accurate analyses, what numeric property of the 'Trans_Amount' variable could you use or modify to correct these values in your programming code?

Options :

A : Set a user-defined format to display negative numbers as positive.

B : Utilize the ABS function to convert negative values to their absolute values.

C : Change the variable-s length to accommodate larger numbers.

D : Implement a WHERE clause to filter out all negative values.

Answer: B

Question 3

An analytics firm is looking to harness the power of in-memory analytics for complex computations and wants to decide between SAS Compute Server and SAS Cloud Analytics Services (CAS). Which scenario best justifies the choice of utilizing CAS over SAS Compute Server?

Options :

A : The firm requires batch processing capabilities for large datasets that do not fit into memory.

B : The company demands a distributed, in-memory analytics engine to analyze big data at unprecedented speeds.

C : There is a need for a traditional analytics environment that supports long-established, disk-based processing.

D : The firm-s analytics workload is light and does not require the advanced, high-performance capabilities of in-memory processing.

Answer: B

Question 4

An analyst is developing a data manipulation task that involves sorting a large dataset and merging it with another. Given two environments, one using serial processing and the other using parallel processing, which of the following statements would be true regarding performance expectations?

Options :

A : Sorting and merging would take longer in the parallel processing environment, as these tasks are I/O intensive.

B : There would be no difference in performance between the two environments as the types of operations involved do not benefit from parallel execution.

C : Sorting and merging would be faster in the serial processing environment due to the simpler nature of the computation.

D : Sorting and merging would benefit from the parallel processing capabilities leading to potential decreases in execution time.

Answer: D

Question 5

When working with the CAS procedure PROC CASUTIL to load data into the CAS server, what is the effect of setting the DATALIMIT= option to a specific value, such as DATALIMIT=100?

Options :

A : It specifies that only the first 100 bytes of the data set should be loaded.

B : It sets the limit for the maximum number of variables to be included in the output table in the CAS server.

C : It imposes a restriction on the number of observation rows to be processed by the CAS action.

D : It controls the maximum number of characters for string variables to be loaded into the CAS server.

Answer: C