Question 1

A programmer wants to utilize the `TABULATE` procedure in SAS Viya for generating a summary report. They need to limit the output to only include the observations for which the 'type' variable equals 'Residential'. Which option demonstrates the correct use of the `WHERE=` parameter in PROC TABULATE to accomplish this task?

Options :

A : `PROC TABULATE DATA=real_estate; WHERE= type = 'Residential'; CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

B : `PROC TABULATE DATA=real_estate TABULATE=WHERE(type = 'Residential'); CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

C : `PROC TABULATE DATA=real_estate; TABLE property_type, price*SUM / WHERE(Type = 'Residential'); CLASS property_type; VAR price; RUN;`

D : `PROC TABULATE DATA=real_estate(table=WHERE(type = 'Residential')); CLASS property_type; VAR price; TABLE property_type, price*SUM; RUN;`

Answer: A

Question 2

When defining a variable in a CAS table using PROC CAS, which of the following data types requires specifying the maximum length attribute?

Options :

A : double

B : varchar

C : int64

D : numeric

Answer: B

Question 3

A SAS Viya data analyst is tasked with selecting a random subset of data from a dataset called 'CustomerData', which contains over 1 million records. The requirement is to analyze a manageable subset without any bias. How should the analyst use the 'subSet=' parameter in a procedure to ensure a random selection?

Options :

A : PROC SURVEYSELECT DATA=CustomerData subSet=/METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

B : PROC SURVEYSELECT DATA=CustomerData METHOD=SRS SAMPRATE=0.01 OUT=SampleData;

C : PROC SURVEYSELECT DATA=CustomerData subSet=(RANDOM 0.01) OUT=SampleData;

D : PROC SURVEYSELECT DATA=CustomerData / subSet=(RANDOM 0.01) OUT=SampleData;

Answer: B

Question 4

In a multi-session SAS Viya environment, a data analyst needs to execute a DATA step that assigns a permanent library using the LIBNAME statement. The analyst needs to ensure that the dataset created within the DATA step is available in the assigned library for all subsequent sessions. Which DATA statement option should the analyst use to specify the session where the library and dataset will be accessible?

Options :

A : SESSREF=SASStudio

B : SESSREF=CASUSER

C : SESSREF=GLOBAL

D : SESSREF=ANALYSIS

Answer: C

Question 5

A data analyst is using the fedSQL action set to combine data from separate tables stored in a distributed environment. They want to perform a left join on two tables, 'customers' and 'orders', based on the customer ID. Which of the following fedSQL statements accomplishes this?

Options :

A : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

B : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers LEFT JOIN orders ON customers.id = orders.customer_id; QUIT;

C : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers t1 LEFT JOIN orders t2 ON t1.customer_id = t2.customer_id; QUIT;

D : PROC FEDSQL; CREATE TABLE results AS SELECT * FROM customers FULL JOIN orders ON customers.customer_id = orders.customer_id; QUIT;

Answer: C

Confidently Practice Online with Free A00-420 Exam Cram

Buying Options: