Question 1

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

Question 2

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 3

Assume that you are working with a large dataset in CAS, and you have a need to create a flag variable that indicates whether certain criteria are met. This flag is based on a calculation that you do not want to repeat in multiple places throughout your DATA step code. How can the `computedVarsProgram=` parameter be utilized to optimize performance and maintainability?

Options :

A : Use the `computedVarsProgram=` parameter to define the flag calculation and reference the flag variable later in the DATA step without redefining the calculation.

B : Set the `computedVarsProgram=` parameter to create a macro variable with the desired flag value so it can be used throughout the DATA step.

C : Apply the `computedVarsProgram=` parameter in multiple DATA steps so each one can perform the flag calculation independently.

D : Invoke the `computedVarsProgram=` parameter at the end of the DATA step to store the results of the flag calculation for subsequent steps.

Answer: A

Question 4

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 5

When using PROC MEANS to summarize data, a programmer needs to display only the variables "Time", "Distance", and "Speed" from a dataset, while also calculating the mean and standard deviation for those variables. Which of the following VAR statements is the most efficient way to achieve this while maintaining the original order in the dataset?

Options :

A : `proc means data=work.RunData mean std; var Time Distance Speed; run;`

B : `proc means data=work.RunData mean std; var Speed Distance Time; run;`

C : `proc means data=work.RunData; var Time Speed; run;`

D : `proc means data=work.RunData; run;`

Answer: A