A00-215 無料問題集「SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4」
You are tasked with analyzing a SAS dataset named 'CustomerData' located on a remote server with the path '/home/data/customer_data'. The dataset is accessible via the SAS client using the 'SAS DATA' library. Which LIBNAME statement should you use to properly access the dataset?
正解：E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are tasked with creating a SAS program to calculate the average income for each state in a dataset. You have a dataset called "income" with variables "State" and "Income". Which of the following SAS code snippets will correctly calculate the average income for each state?
正解：A、C、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are analyzing a dataset containing sales transactions for a retail store. Each transaction record has the following variables: '' TransactionDate'', ' 'CustomerlD'', ' 'ProductlD'', ' 'Quantity'', and ''UnitPrice''. You need to calculate the total sales for each customer, but only for transactions occurring in the month of January. How would you use the SUM statement within a DATA step to achieve this? Assume you've already filtered the dataset to include onl Janua transactions.
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', and 'CITY'. You want to create a new dataset 'NEW CUSTOMERS' containing only the records where the 'CITY' variable is missing (missing value). Additionally, you want to add a new variable named 'STATUS' with a default value 'NEW' for all observations in the 'NEW CUSTOMERS' dataset. Which SAS code snippet would achieve this?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset with a variable called 'DateOfBirth' in the format 'MMDDYY'. You need to create a new variable 'Age' that calculates the patient's age in years based on today's date. Which code snippet correctly calculates the age and handles leap years accurately?
正解：E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset 'ORDERS' with variables 'ORDER ID', 'CUSTOMER ID', 'ORDER DATE', and 'TOTAL AMOUNT'. You want to create a dataset 'HIGH VALUE ORDERS' containing only observations from the 'ORDERS' dataset where the 'TOTAL AMOUNT' is greater than 5000 and the 'ORDER DATE' falls between '01JAN2023'd and '31 MAR2023d. Which of the following DATA step code snippets will achieve this?
正解：A、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a SAS dataset named 'SALES' with variables 'REGION', 'PRODUCT', 'SALES AMOUNT', and 'SALES DATE'. You need to create a new dataset called 'REGIONAL SALES' that only includes the 'REGION' and 'SALES AMOUNT' variables for sales that occurred in the year 2023. Which code snippet will correctly achieve this?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset 'ORDERS' with variables 'ORDER D', 'CUSTOMER ID', and 'ORDER DATE'. You want to create a new dataset 'RECENT ORDERS' containing only the records where the 'ORDER DATE' is within the last 30 days (excluding today) and only the 'ORDER ID' and 'CUSTOMER ID' variables should be included. The date format is 'YYYY-MM-DD'. Which SAS code snippet would achieve this correctly?
正解：C、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset 'SalesData' with a variable 'ProductName' that contains lengthy product names. You want to modify the display of the 'ProductName' variable in output reports, replacing the word 'Product' with 'Item' while maintaining the original variable name 'ProductName'. Which SAS statement(s) would achieve this?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a CSV file named 'customer_data.csv' containing customer information. You need to import this data into a SAS dataset, selecting only specific columns and filtering based on a condition. Which code snippet correctly imports the data, performs the selection, and applies the filter?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset containing a variable 'Product_Code' with values like 'ABCI 234', 'DEF5678', 'GH19012'. You want to extract the first 3 characters of each product code and store them in a new variable 'Product Category'. Which code snippet correctly achieves this using the SUBSTR function?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset containing employee information, including their 'Department' and 'Salary' variables. You want to create a frequency report for the 'Department' variable, but you want the departments to be displayed in the order of their average salary (highest average salary first). Which of the following options would achieve this?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset 'CUSTOMER DATA' with variables 'CUSTOMER ID', 'NAME', 'ADDRESS', 'CITY', 'STATE', and ZIP'. You need to create a new dataset 'SELECTED CUSTOMERS' containing all customers from 'CITY' 'New York' and 'Los Angeles', while keeping only the variables 'CUSTOMER ID' and 'NAME'. Which code snippet correctly achieves this?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a dataset with a variable 'SalesAmount' representing sales figures. You need to create a new variable called 'SalesCategory' that categorizes sales based on thresholds: 0-1000 as 'Low', 1001-5000 as 'Medium', and above 5000 as 'High'. Which code snippet correctly uses a FORMAT statement to achieve this?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)