Free SAS Institute A00-420 Exam Questions

Become SAS Institute Certified with updated A00-420 exam questions and correct answers

Page: 1 / 59

Total 291 Questions | Updated On: Jul 23, 2025

Add To Cart

Question 1

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?

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

Question 2

You are working with a large, partitioned dataset in a CAS session and you want to ensure that a PROC MEANS calculation is performed in parallel across all data partitions to enhance performance. Which option would you use to accomplish this?

A : Use the PARTBY statement in the PROC MEANS code to specify the variable that defines the data partitions.

B : Explicitly define a BY statement and sort the data by the partitioning variable before calling PROC MEANS.

C : Use the NWAY option in the PROC MEANS code to enforce group processing only on the class variables.

D : Implement an ORDER BY clause in a preceding PROC SQL step to arrange the data by partitions.

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?

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

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?

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 5

You are required to modify an existing table named "sales_data" by adding a new column titled "discount_amount" that will store numerical values representing the discount given for each sale. Which of the following ALTER TABLE statements would correctly add the required column?

A : ALTER TABLE sales_data ADD COLUMN discount_amount NUMERIC;

B : ALTER TABLE sales_data ADD discount_amount NUMERIC;

C : ALTER TABLE sales_data APPEND COLUMN discount_amount NUMERIC;

D : ALTER TABLE sales_data INCORPORATE discount_amount AS NUMERIC;

Answer: A

Page: 1 / 59

Total 291 Questions | Updated On: Jul 23, 2025

Add To Cart