SASInstitute A00-215 問題集

質問 1：
You want to analyze the relationship between the 'Income' and 'Education' variables in a dataset. You want to generate a report showing the average income for each education level (High School, College, Graduate) and also include the total number of observations for each education level. Which PROC MEANS statement would you use?
A.

B.

C.

D.

E.

正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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.

B.

C.

D.

E.

正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have a dataset 'CustomerData' with variables 'CustomerlD', 'Age', and 'Income'. You want to create a new dataset 'CustomerSegments' with 'CustomerlD' and 'Segment' variables. The 'Segment' variable should be assigned based on the following rules: 1. If 'Age' is less than 30 and 'Income' is greater than 50,000, assign 'Young Professionals'. 2. If 'Age' is between 30 and 50 and 'Income' is greater than 75,000, assign 'Mid-Career Earners'. 3. If 'Age' is greater than 50 and 'Income' is greater than 100,000, assign 'Senior Executives'. 4. For all other cases, assign 'Other'. Which of the following code snippets will produce the correct 'CustomerSegments' dataset?
A.

B.

C.

D.

E.

正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are working with a SAS dataset named 'CUSTOMERS' that has a variable called 'NAME'. You need to create a new variable called 'NAME LENGTH' that stores the length of each customer's name. Which of the following SAS code snippets would achieve this correctly?
A.

B.

C.

D.

E.

正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have a SAS dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You want to create a new dataset named 'HIGH SALES' containing only observations where 'SALES AMOUNT' is greater than 10000 and the 'REGION' is 'North'. Which of the following DATA step code snippets would achieve this?
A.

B.

C.

D.

E.

正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You have a SAS dataset named 'SALES' with a variable 'ORDER DATE' representing the order date in a numeric date format. You need to create a new variable 'MONTH NAME' that displays the full month name corresponding to the 'ORDER DATE'. Which SAS code snippet achieves this?
A.

B.

C.

D.

E.

正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have a dataset with a variable 'Age' containing missing values. You need to create a format that labels all missing values as 'Unknown Age' and all other values as 'Age Provided'. Which PROC FORMAT code snippet achieves this?
A.

B.

C.

D.

E.

正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are analyzing customer data in a SAS data set named 'CUSTOMER DATA'. You need to create a new data set called 'ACTIVE CUSTOMERS that contains only customers who have made a purchase in the last 12 months. The 'CUSTOMER DATA' dataset has the following variables: CUSTOMER D, LAST PURCHASE DATE. Which DATA step code snippet correctly accomplishes this task?
A.

B.

C.

D.

E.

正解：A
解説: (Topexam メンバーにのみ表示されます)