Free SAS Institute A00-415 Exam Questions

Question 1

A programmer wants to accumulate the total sales for each month in a dataset named 'monthly_sales' that has two variables: 'month' and 'sales'. Which DATA Step code properly accumulates the total sales for each month?

A : data totals;set monthly_sales;retain total_sales;total_sales + sales;run;

B : data totals;set monthly_sales;by month;if first.month then total_sales=0;total_sales + sales;if last.month then output;run;

C : data totals(drop=month);set monthly_sales;total_sales + sales;output;run;

D : data totals;set monthly_sales;retain total_sales 0;total_sales + sales;output;run;

Answer: B

Question 2

A programmer wants to accumulate the total sales for each month in a dataset named 'monthly_sales' that has two variables: 'month' and 'sales'. Which DATA Step code properly accumulates the total sales for each month?

A : data totals;set monthly_sales;retain total_sales;total_sales + sales;run;

B : data totals;set monthly_sales;by month;if first.month then total_sales=0;total_sales + sales;if last.month then output;run;

C : data totals(drop=month);set monthly_sales;total_sales + sales;output;run;

D : data totals;set monthly_sales;retain total_sales 0;total_sales + sales;output;run;

Answer: B

Question 3

A data analyst is preparing a report using PROC REPORT in SAS Viya. The analyst needs to display customer details from the 'customers' table but wants only the 'CustomerID', 'FirstName', 'LastName', and 'Email' columns to be included in the report. Which TABLE statement below would correctly produce this output?

A : TABLE customers(CustomerID, FirstName, LastName, Email);

B : TABLE customers ALL COLUMNS;

C : TABLE customers(SELECT CustomerID, FirstName, LastName, Email FROM customers);

D : TABLE customers VAR CustomerID FirstName LastName Email;

Answer: A

Question 4

When a user submits a PROC MEANS in a SAS Viya environment, the procedure is automatically directed to run in a specific execution context based on the data's location. Assuming the PROC MEANS is using a dataset that resides within the CAS server, where will the code execute?

A : The code will execute locally on the user's machine.

B : The code will execute on the SAS Viya compute server accessing the data via implicit SQL pass-through.

C : The code will execute within the CAS server where the dataset resides.

D : The code execution will prompt the user to choose the execution environment. E. The code will execute within the SAS Viya environment, but the exact location will be determined by the network latency.

Answer: C

Question 5

A data analyst needs to append two tables, `sales2019` and `sales2020`, which reside in the CAS environment. Both tables have the same structure and variables, but each contains records from the respective year. Which CAS action should the analyst use to perform this task efficiently?

A : table.save

B : table.concat

C : table.append

D : datastep.runcode

Answer: B