Question 1

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 2

What is the correct way to use the CAS library to save the results of a procedure in SAS Viya?

Options :

A : Use a DATA step with the CASLIB statement to specify the target CAS library where the results should be saved.

B : Use the PROC COPY command with the TO= and FROM= options to move result tables to a specified CAS library.

C : Assign a libref to the desired CAS library and then specify that libref in the OUT= option of the procedure.

D : Result tables are automatically saved to the CAS library assigned to the user at login and no additional steps are required.

Answer: C

Question 3

When using the dataStep action set in SAS Viya, you need to create a new table that includes a calculated column based on conditional processing of other columns in the data. Which of the following OPTIONS correctly demonstrates how to create a new variable that assigns a value of 'High' if the variable 'Sales' is above 1000 and 'Low' if 'Sales' is 1000 or below using the dataStep.runCode action?

Options :

A : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

B : datastep.runCode / code="data newTable; set oldTable; if Sales then if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; run;";

C : datastep.runCode / code="proc newTable; set oldTable; if Sales > 1000 then Sales_Level = 'High'; else Sales_Level = 'Low'; end;";

D : datastep.runCode / code="data newTable; set oldTable; if Sales > 1000 then do; Sales_Level = 'High'; end; else do; Sales_Level = 'Low'; end; run;";

Answer: A

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

Higher Test Marks with Free Online A00-420 Exam Practice

Buying Options: