최신 A00-215 무료덤프 - SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4
You have a dataset with a variable 'REGION' containing values like 'North America', 'South America', 'Europe', etc. You want to create a custom format that abbreviates these values to 'NA', 'SA', 'EU', respectively. Which PROC FORMAT code snippet achieves this?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS dataset called 'CUSTOMERS' with variables: 'CustomerlD', 'Name', 'City', 'State', 'Zip', 'Phone', 'Email'. You want to create a new dataset called 'CUSTOMER INFO' containing only the variables 'Name', 'City', and 'Email', but you also need to remove duplicate records based on the 'CustomerlD' variable. Which code snippet correctly accomplishes this?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset with a variable 'START DATE' representing the start date ofa project. You want to create a new variable 'END DATE' which is set to the 1st of the month following 'START DATE'. Which code snippet correctly calculates 'END DATE'?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset with a variable 'SALES' containing sales values. You need to create a new variable 'SALES CATEGORY' that categorizes sales as follows: - 'High' if SALES is greater than or equal to 10000 - 'Medium' if SALES is greater than or equal to 5000 but less than 10000 - 'Low' if SALES is less than 5000 Which code snippet correctly achieves this using the INT function?
정답: E
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset 'CUSTOMERS' with a variable 'CITY containing city names and a variable ZIP CODE'. You want to create a sorted dataset 'CUSTOMERS SORTED' where the city names are sorted alphabetically, but within each city, the ZIP codes are sorted in descending order. How would you achieve this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
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?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You are generating a report using PROC REPORT and want to add a footnote at the bottom of each page that explains the data source. Which of the following FOOTNOTE statement options is most appropriate for achieving this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You are working with a dataset named 'work.customer' that contains a variable called 'age' representing the age of customers. You want to create a new variable 'age_group' based on the following criteria: 'age_group' = Young' if 'age' is less than 30 'age_group' = 'Middle' if 'age' is between 30 and 50 (inclusive) 'age_group' = 'Senior' if 'age' is greater than 50 Which SAS code snippet correctly creates the 'age_group' variable?
정답: B,D
설명: (DumpTOP 회원만 볼 수 있음)
You are working with a dataset containing customer information and their purchase history. You need to generate a report showing the number of unique customers who made a purchase in each state, but only for customers who have made a purchase in more than one state. Which of the following SAS code snippets would achieve this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS dataset named 'CUSTOMERS' with variables 'CUSTOMER ID', 'CITY', 'STATE', and 'SALES'. You need to create a new dataset called 'HIGH SALES' containing only customers from the state 'CA' who have sales greater than $10000. Which code snippet will achieve this?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have two SAS datasets, 'SALES' and 'CUSTOMERS', with a common key variable 'CUSTOMER ID. You need to merge these datasets, but you only want to keep records from 'SALES' that have a corresponding match in 'CUSTOMERS'. Which of the following code snippets correctly accomplishes this using the IN= option within a MERGE statement?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset with patient data, including age and blood pressure. You need to create a new variable 'RiskLevel' that assigns a 'High' risk if the patient is above 60 years old and has a systolic blood pressure greater than 140. If the patient is above 60 years old but has a systolic blood pressure below 140, the risk level should be 'Moderate'. Otherwise, the risk level should be 'Low'. Which code snippet correctly implements this logic using the IF-THEN-ELSE statements?
정답: E
설명: (DumpTOP 회원만 볼 수 있음)
You are working with a dataset 'SALES DATA' containing sales information. You have variables 'PRODUCT ID' (character), 'SALES DATE' (numeric, in SAS date format), and 'UNITS SOLD' (numeric). You want to calculate the total units sold for each product within the past year. Which code snippet correctly achieves this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset containing customer demographics, purchase history, and loyalty program status. You want to create a report that shows the average purchase amount for customers who are active in the loyalty program and have made at least 3 purchases in the past year. Which of the following SAS code snippets would achieve this?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS dataset named 'SALES' with a variable 'REGION' that contains region codes. You want to generate a report that displays the region codes as 'East Coast', 'West Coast', 'Midwest', and 'South' based on their corresponding numeric values. Which code snippet correctly uses the LABEL statement to achieve this?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You're working with a dataset containing student records. You need to generate a report that shows the average grade for each student, but only for students who have taken at least two courses. Utilize the OUTPUT statement to control output timing and ensure only students with enough courses are included in the report. Which code snippet correctly implements this?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset 'Sales' with a variable 'SaleDate' in a DATE format. You need to create a new variable 'Quarter' that identifies the quarter of the year for each sale. What SAS code would accomplish this?
정답: C,D
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS report generated using ODS and want to create a PDF file with a specific page size (Letter) and orientation (Landscape). Which ODS destination option will allow you to achieve this?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)