최신 A00-215 무료덤프 - SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4
Which of the following statements about global SAS statements are true? (Select all that apply)
정답: A,B,E
설명: (DumpTOP 회원만 볼 수 있음)
You are analyzing a dataset containing customer transactions with a 'Transaction_Date' variable in the format 'YYMMDDI You need to create a new variable called 'Days_Since Last_Transaction' that calculates the number of days between each transaction for each customer, sorted by 'CustomerlD' and 'Transaction_Date'. Which code snippet correctly performs this calculation?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset with a variable 'DATE STR' storing dates in the format 'YYYY-MM-DD'. You want to create a new variable 'DATE NUM' storing the date in numeric format (YYYYMMDD). Which code snippet correctly achieves this transformation?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You are importing a large CSV file with millions of rows. Due to memory limitations, you want to import the data in chunks. How can you use PROC IMPORT to efficiently import the file in chunks?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS dataset 'work.sales' with variables 'sales_amt', and 'product id'. You want to create a new dataset that summarizes total sales by 'product id'. Which of the following PROC steps would achieve this?
정답: B,D
설명: (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 are analyzing a dataset 'Products' with variables 'Product_Type' and 'Sales _ Amount'. You need to generate a frequency report for 'Product_Type' and include the 'Sales_Amount' sum for each type. Additionally, the report should display the product types in ascending order based on their sales amount. Which PROC FREQ statement accomplishes this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You are debugging a SAS program that uses a macro. The macro generates an error message "ERROR: The macro variable &MACRO VAR does not exist.". Which of the following is the MOST likely reason for this error?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', 'SALES AMOUNT', and 'SALES DATE'. You want to generate a report that only displays the 'REGION' and 'SALES AMOUNT' variables for sales transactions in the 'South' region and within the last 3 months. Which PROC PRINT statement would achieve this?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You are working with a SAS dataset containing both numeric and character variables. You want to check if there are any missing values in the dataset. Which SAS function would you use to achieve this?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset called ' 'SalesData'' with variables ''Region SalesPerson Product'', and ' 'Revenue' '. You need to create a new dataset called ' 'RegionSummary'' that calculates the total revenue for each region, and then identifies the top-performing salesperson in each region (based on total revenue). Which SAS code accurately uses the SUM statement to achieve this, and includes appropriate logic to identify the top salesperson?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You have a SAS dataset named 'CUSTOMERS' with variables 'CUST ID' and 'CITY'. You want to generate a report that displays the city names in a column titled 'Location' instead of 'CITY' and assign a specific label to the 'CUST ID' variable. Which code snippet correctly uses the LABEL statement for the required modifications?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You need to create a new character variable called 'Phone Number' in a dataset, which should store phone numbers in the format (XXX) XXX-XXXX. You want to ensure that the variable is capable of storing the entire formatted phone number and no more. Which of the following LENGTH statements will correctly define the variable and ensure that the format is preserved? ' 'Note' ': Assume that the original variable 'Phone' holds phone numbers in the format XXXXXXXXXX.
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You are working with a large Excel spreadsheet containing sensitive customer dat a. You need to import this data into SAS for analysis while ensuring data security and preventing accidental modifications. Which of the following options correctly utilizes the LIBNAME statement and XLSX engine to achieve this objective?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
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?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset named 'CUSTOMERS' with variables 'Customer_lD', 'Name', 'City', and 'State'. You need to generate a report that displays the first 10 observations of the dataset, along with a title 'Customer Information (Top 10)' and a footer that indicates the date the report was generated. Which PROC PRINT statement with LABEL and NOOBS options would achieve this?
정답: A,E
설명: (DumpTOP 회원만 볼 수 있음)
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?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have a dataset with a variable 'SALES' containing values like 123.45, 67.89, 90.12. You need to round these values to the nearest integer. Which SAS code snippet accomplishes this correctly?
정답: B,E
설명: (DumpTOP 회원만 볼 수 있음)