최신SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215무료샘플문제
문제1
You are working with a SAS dataset named 'SALES containing information about sales transactions. The dataset has a variable 'PRODUCT ID' and 'QUANTITY SOLD'. You want to create a new dataset 'SALES SUMMARY' that summarizes the total quantity sold for each product. Which code snippet would you use to achieve this?
You are working with a SAS dataset named 'SALES containing information about sales transactions. The dataset has a variable 'PRODUCT ID' and 'QUANTITY SOLD'. You want to create a new dataset 'SALES SUMMARY' that summarizes the total quantity sold for each product. Which code snippet would you use to achieve this?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
You have an Excel file 'customer data.xlsx' with two sheets: 'Customers' and 'Orders'. The 'Customers' sheet contains customer IDs and names, while the 'Orders' sheet contains order IDs, customer IDs, and order dates. You want to create a SAS dataset 'combined_data' that joins data from both sheets based on the common 'Customer ID' column. Which code snippet correctly accomplishes this?
You have an Excel file 'customer data.xlsx' with two sheets: 'Customers' and 'Orders'. The 'Customers' sheet contains customer IDs and names, while the 'Orders' sheet contains order IDs, customer IDs, and order dates. You want to create a SAS dataset 'combined_data' that joins data from both sheets based on the common 'Customer ID' column. Which code snippet correctly accomplishes this?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to sort the data first by 'REGION' in ascending order and then by 'PRODUCT' in descending order, creating a new dataset named 'SORTED SALES'. Which PROC SORT statement would achieve this?
You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to sort the data first by 'REGION' in ascending order and then by 'PRODUCT' in descending order, creating a new dataset named 'SORTED SALES'. Which PROC SORT statement would achieve this?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
You have a SAS data set called 'raw_data' with variables 'name', 'city', 'age', and 'occupation'. You want to create a new data set called 'processed_data' that contains only observations where the 'occupation' is 'Doctor' or 'Nurse' and the 'age' is greater than 40. You also want to add a new variable 'status' to the processed data set. The 'status' variable should be assigned 'High Risk' if the 'age' is greater than 60, 'Medium Risk' if the age is between 40 and 60, and 'Low Risk' if the age is less than 40. Which of the following code snippets correctly implements this transformation?
You have a SAS data set called 'raw_data' with variables 'name', 'city', 'age', and 'occupation'. You want to create a new data set called 'processed_data' that contains only observations where the 'occupation' is 'Doctor' or 'Nurse' and the 'age' is greater than 40. You also want to add a new variable 'status' to the processed data set. The 'status' variable should be assigned 'High Risk' if the 'age' is greater than 60, 'Medium Risk' if the age is between 40 and 60, and 'Low Risk' if the age is less than 40. Which of the following code snippets correctly implements this transformation?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
You are tasked with creating a SAS program to calculate the average salary of employees in a department. Your program should include a 'WHERE' clause to filter for employees in the 'Sales' department. However, when you run the program, the output shows the average salary of all employees, not just those in the 'Sales' department. Which of the following is the most likely cause of this problem? Select all that apply.
You are tasked with creating a SAS program to calculate the average salary of employees in a department. Your program should include a 'WHERE' clause to filter for employees in the 'Sales' department. However, when you run the program, the output shows the average salary of all employees, not just those in the 'Sales' department. Which of the following is the most likely cause of this problem? Select all that apply.
정답: A,B
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
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?
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?
정답: E
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
You have a dataset called 'sales' with sales data for different products. You want to calculate the mean, standard deviation, and median sales values for each product category, displaying the mean and standard deviation to three decimal places. The dataset has variables 'product_category', 'product_name', and 'sales_amount'. Which PROC MEANS statement correctly performs this task?
You have a dataset called 'sales' with sales data for different products. You want to calculate the mean, standard deviation, and median sales values for each product category, displaying the mean and standard deviation to three decimal places. The dataset has variables 'product_category', 'product_name', and 'sales_amount'. Which PROC MEANS statement correctly performs this task?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제8
Consider the following DATA step code:
Which of the following statements are TRUE about the execution of this code? 1. The variable 'name' will be truncated to 10 characters during input. 2. The variable 'name' will be automatically padded with spaces if it is less than 10 characters. 3. The variable 'id' will be assigned a default length of 8 bytes. 4. The variable 'age' will be assigned a default length of 8 bytes. 5. The variable 'name' will be assigned a default length of 20 bytes.
Consider the following DATA step code:
Which of the following statements are TRUE about the execution of this code? 1. The variable 'name' will be truncated to 10 characters during input. 2. The variable 'name' will be automatically padded with spaces if it is less than 10 characters. 3. The variable 'id' will be assigned a default length of 8 bytes. 4. The variable 'age' will be assigned a default length of 8 bytes. 5. The variable 'name' will be assigned a default length of 20 bytes.
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제9
You are tasked with generating a series of reports for different departments, each with its unique title and a consistent footer containing the report generation date. How can you achieve this using the TITLE statement effectively? Select all that apply.
You are tasked with generating a series of reports for different departments, each with its unique title and a consistent footer containing the report generation date. How can you achieve this using the TITLE statement effectively? Select all that apply.
정답: B,D,E
설명: (KoreaDumps 회원만 볼 수 있음)