A00-215試験無料問題集（390題）「SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 認定」

出題：1

You have a SAS data set named 'PRODUCTS' with variables 'ProductlD', 'ProductName', 'Price', and 'Category'. You need to create a new data set 'PRODUCT SALES' with only the products in the 'Electronics' category, and you want to include a new variable called 'TotalSales' calculated as 'Price 100' for each product. Which SAS code snippet achieves this?

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You are working with a large dataset containing information on customer transactions. You need to generate a report showing only transactions that occurred in the month of December and involved amounts greater than $1000. Which of the following WHERE statements would achieve this?

A. WHERE TRANSACTION DATE = 'DEC' AND AMOUNT > 1000,

B. WHERE = 12 AND AMOUNT > 1000;

C. WHERE TRANSACTION DATE '12/01/2023' AND TRANSACTION DATE '12/31/2023' AND AMOUNT > 1000,

D. WHERE TRANSACTION DATE BETWEEN '12/01/2023' AND '12/31/2023' AND AMOUNT > 1000,

E. WHERE TRANSACTION DATE LIKE AND AMOUNT > 1000;

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You have a dataset containing product information, including a variable named 'Category' with values such as 'Electronics', 'Clothing', 'Food', and 'Furniture'. You want to create a report that displays the total sales for each category, but you want to group 'Food' and 'Furniture' together under a new label 'Home & Living'. Which approach would you use?

A. PROC PRINT DATA=Your Data set; LABEL Category = 'Home & Living' WHEN (Category='Food' OR Category-'Furniture'); RUN;

B. PROC MEANS DATA=Your Data set; CLASS Category; VAR sales; LABEL Category = 'Home & Living' WHEN (Category='Food' OR Category='Furniture'); RUN;

C. PROC SUMMARY DATA-Your Data set; CLASS Category; VAR sales; OUTPUT OUT-Summary; LABEL Category = 'Home & Living' WHEN OR Category='Furniture'); RUN;

D. PROC SOL; SELECT SUM(Sales), CASE WHEN Category IN ('Food', 'Furniture') THEN 'Home & Living' ELSE Category END AS Category FROM Your Data set GROUP BY Category; RUN;

E. PROC REPORT DATA-Your Data set; CLASS Category; DEFINE Sales / SUM; LABEL Category = 'Home & Living' WHEN (Category='Food' OR Category-'Furniture'); RUN;

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You have a dataset 'CUSTOMER' with variables 'CUSTOMER ID', 'NAME', and 'STATE'. You need to sort the dataset based on 'STATE', but only for customers whose 'CUSTOMER ID' is greater than 1000. Which PROC SORT statement would achieve this?

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

You have a dataset with a variable 'Sales' containing numeric values. You need to create a new variable 'SalesCategory' that classifies the sales values into three categories: 'Low' (Sales < 1000), 'Medium' (1000 <= Sales < 5000), and 'High' (Sales >= 5000). Which SAS code snippet correctly implements this using the DO loop and IF-THEN/ELSE statements?

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You have a SAS dataset with a date variable 'START DATE' in the format 'YYYY-MM-DD'. You want to calculate the number of days between the 'START DATE' and the current date. Which SAS code snippet achieves this correctly?

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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'?

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You need to create a new variable 'FULL NAME' by concatenating the values from variables 'FIRST NAME', 'MIDDLE NAME', and 'LAST NAME', separated by a space. However, the 'MIDDLE NAME' variable might be missing for some observations. Your code should handle this scenario by only including the 'MIDDLE NAME' if it is not missing. Which code snippet accomplishes this task using the 'CAT X' function?

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

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?

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'ORDER DATE', and 'ORDER AMOUNT'. You need to calculate the total order amount for each customer and then calculate the average order amount across all customers. Which code snippet achieves this correctly?

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

You have a SAS data set 'SALES DATA' with a variable 'DATE' representing the sale date. You need to create a new data set 'SALES BY MONTH' that summarizes sales by month. You want to include only the observations from the 'SALES DATA' dataset where the 'DATE' variable falls between January 1st and March 31st of the current year. How would you achieve this, using the SET statement and the IN T NX function?

A. data SALES BY MONTH; set SALES_DATA; if 'OlJAN2023'd and '31 MAR2023'd then output; run;

B. data set SALES_DATA; if date 'OlJAN2023'd and date '31 MAR2023'd then output; run;

C. data set SALES_DATA; if = 'OlJAN2023'd then output; run;

D. data SALES BY MONTH; set SALES_DATA; if 'OlJAN2023'd and '31 MAR2023'd then output; run;

E. data SALES_BY MONTH; set SALES_DATA; if 'OlJAN2023'd and '31 MAR2023'd then output; run;

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

You are analyzing a SAS dataset with a variable 'CITY' of type character. You want to replace all missing values in 'CITY' with the value 'UNKNOWN' using a data step. Which code snippet correctly achieves this?

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

A00-215試験無料問題集「SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 認定」