SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215무료 덤프문제 풀어보기
You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'ORDER DATE', and 'ORDER AMOUNT'. You need to calculate the total order amount for each customer and then calculate the average order amount across all customers. Which code snippet achieves this correctly?
정답: E
설명: (Fast2test 회원만 볼 수 있음)
Consider the following SAS code snippet:
What is the main logical error in this code?
What is the main logical error in this code?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You are analyzing a dataset named 'EMPLOYEES' with variables 'EmployeelD', 'Department', and 'Salary'. You want to create a new dataset 'HIGHEST SALARY' that contains the employee with the highest salary in each department. Which SAS code snippet correctly performs this task?
정답: A,E
설명: (Fast2test 회원만 볼 수 있음)
You are analyzing a dataset called 'SalesData' with variables 'Region' (character) and 'SalesAmount' (numeric). You need to generate a frequency table that includes both the frequencies and percentages of each 'Region' category, and also display the cumulative frequencies and percentages. Which of the following options is the correct code snippet for this task?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You have a CSV file 'customer_data.csv' with columns 'customer_id', 'name', 'city', 'state', 'zip_code'. You want to import this data into a SAS dataset called 'CUSTOMERS' using PROC IMPORT. However, the 'zip_code' column in the CSV file contains leading zeros. You want to import 'zip_code' as a character variable while preserving the leading zeros. How would you modify the PROC IMPORT statement to accomplish this?
정답: E
설명: (Fast2test 회원만 볼 수 있음)
You have a SAS dataset called 'SALES' with variables 'Region', 'Product', 'Sales', 'Quantity', and 'Date'. You want to create a new dataset called 'Top_Sales' containing only the 'Region', 'Product', and 'Sales' variables for the top 10 regions with the highest total sales. Which code snippet would achieve this correctly?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
You are working with a dataset containing a variable called 'SALES' with numeric values. You need to categorize the sales values into three groups: 'Low', 'Medium', and 'High' based on their ranges. Which code snippet correctly defines a custom format using PROC FORMAT and the VALUE statement to achieve this?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You are working with a dataset containing customer demographics. You need to create a new variable called 'AgeGroup' that categorizes customers into three groups: 'Young' (age < 25), 'Adult' (25 <= age < 50), and 'Senior' (age >= 50). Which of the following code snippets would achieve this using an iterative DO loop?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You have a dataset containing a variable 'Full Name' with values like 'John Doe', 'Jane Smith', 'Peter Jones'. You want to extract the last name from each observation and store it in a new variable called 'Last Name'. Which code snippet correctly achieves this using the FIND and SUBSTR functions?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You have a dataset called 'Sales' with variables 'Region', 'Product', and 'SalesAmount'. You need to create a new variable called 'Bonus' that assigns a 10% bonus to sales in the 'North' region only if the 'SalesAmount' is greater than $1000. Which code snippet correctly accomplishes this?
정답: E
설명: (Fast2test 회원만 볼 수 있음)
You are tasked with creating a report that displays sales data in a specific format for a client. The report needs to be exported as a PDF file with a custom logo and footer. Which ODS statements would you use to achieve this? ' 'NOTE:'' The data is stored in a SAS dataset called 'SalesData'.
정답: A,B
설명: (Fast2test 회원만 볼 수 있음)
You have a SAS dataset named 'CustomerData' with variables 'CustomerlD', 'OrderDate', and 'Order Total'. You want to create a report that shows the total order amount for each customer who placed an order in the year 2022. The dataset is sorted by 'CustomerlD' and then by 'OrderDate'. Which of the following code snippets would correctly generate the report using PROC SQL?
정답: B,C,D
설명: (Fast2test 회원만 볼 수 있음)
Consider the following SAS code:
What value will be printed for variable 'x' in the output?
What value will be printed for variable 'x' in the output?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
You have a dataset 'EMPLOYEES' with variables 'EMPLOYEE ID', 'NAME', 'DEPARTMENT', 'SALARY', and 'JOIN DATE'. You need to sort the data by 'DEPARTMENT' in ascending order, then by 'SALARY' in descending order, and finally by 'JOIN DATE' in ascending order. Which PROC SORT statement will achieve this sorting?
정답: D
설명: (Fast2test 회원만 볼 수 있음)