A00-420 Practice Online

Question 1

A SAS programmer wants to delete certain observations from a data set 'sales' where the 'product_code' is '1234'. The data set is indexed by 'product_code'. Which combination of statements is the most efficient way to accomplish this task?

A : MODIFY sales; WHERE product_code = '1234'; REMOVE;

B : MODIFY sales; IF product_code = '1234'; DELETE;

C : REPLACE sales; IF product_code = '1234'; DELETE;

D : MODIFY sales BY product_code; IF product_code = '1234'; REMOVE;

Answer: B

Question 2

As a data analyst, you are tasked with utilizing multiple CAS sessions in your SAS Viya program to segregate various data management tasks. Given that you need to switch between these CAS sessions within the same program, how would you specify a particular session for the DATA step to run in?

A : proc cas data=mydata; set casdata; sessref=session2; run;

B : data mydata / sessref=session2; set casdata; run;

C : data mydata; set casdata; cas sessref=session2; run;

D : data mydata (sessref=session2); set casdata; run;

Answer: D

Question 3

A programmer wants to create a new variable that increments by 1 each time a new group, defined by the BY statement, is encountered in the dataset. Which SAS programming technique can achieve this?

A : Utilize the FIRST. variable that is automatically created when using a BY statement to increase a counter variable when FIRST.variable is true.

B : Use a RETAIN statement to carry the value of the counter variable from one group to the next, resetting it to 1 whenever the BY group changes.

C : Implement a WHERE statement to filter the dataset according to the BY group and then accumulate the counter for each group separately.

D : Apply the SUM statement with the BY variable to increment the counter without using FIRST. or RETAIN statements.

Answer: A

Question 4

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?

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 5

An analyst is using fedSQL to write a query that requires case-sensitive string comparison between two columns, 'user_name' from the 'user_accounts' table and 'login' from the 'login_attempts' table. Given that the database is case-insensitive by default, which of the following code snippets would correctly perform a case-sensitive comparison?

A : SELECT * FROM user_accounts INNER JOIN login_attempts ON user_accounts.user_name = login_attempts.login;

B : SELECT * FROM user_accounts INNER JOIN login_attempts ON BINARY user_accounts.user_name = login_attempts.login;

C : SELECT * FROM user_accounts INNER JOIN login_attempts ON STRCMP(user_accounts.user_name, login_attempts.login) = 0;

D : SELECT * FROM user_accounts INNER JOIN login_attempts ON UPPER(user_accounts.user_name) = UPPER(login_attempts.login);

Answer: B

Name:	SAS Viya Intermediate Programming
Exam Code:	A00-420
Certification:	SAS Foundation
Vendor:	SAS Institute
Total Questions:	291
Last Updated:	May 13, 2024

Download Demo A00-420 Dumps

Create Account

Password Recovery

A00-420 Practice Online

Download Demo A00-420 Dumps

Member Login

Create Account

Password Recovery

A00-420 Practice Online