Question 1

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 2

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 3

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 4

You have a CAS table named "sales_data" and you want to use the ALTERTABLE CASDATA statement in SAS Viya to change the data type of the column "total_sales" from varchar to double. Assuming the column "total_sales" exists and originally contains character data representing numeric values, which of the following statements would correctly alter the column data type?

Options :

A : ALTER TABLE CASDATA.sales_data MODIFY COLUMN total_sales SET TYPE double;

B : ALTER TABLE CASDATA.sales_data ALTER COLUMN total_sales TYPE double;

C : ALTER TABLE CASDATA.sales_data CHANGE COLUMN total_sales total_sales double;

D : ALTER TABLE CASDATA.sales_data MODIFY total_sales TYPE TO double;

Answer: B

Question 5

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

Free A00-420 Mock Exam – Practice Online Confidently

Buying Options: