次の認定試験に速く合格する！

簡単に認定試験を準備し、学び、そして合格するためにすべてが必要だ。

会員センターカート (0)

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

ページ: 1 / 25
トータル 390 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

質問 1

You have a SAS data set named 'SALES' with variables 'Region', 'Product', and 'Sales'. You need to create a new data set 'SALES SIJMMARY' containing only the regions with total sales greater than 1000. Which code snippet achieves this, assuming you want to include the total sales for each region in the new dataset?

（A）

（B）

（C）

（D）

（E）

正解：A 解答を投票する

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

質問 2

You need to export data from a SAS dataset 'CUSTOMERS' to a CSV file 'customer_list.csv' with specific formatting. The 'FIRST NAME' and 'LAST NAME' variables should be enclosed in double quotes ("), and the delimiter should be a semicolon (;). Which PROC EXPORT statement achieves this?

（A）

（B）

（C）

（D）

（E）

正解：C 解答を投票する

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

質問 3

You have a dataset with student exam scores. Each student has multiple exam scores, and you need to calculate the average score for each student, but only for their top three highest scores. You need to use the FIRST. And LAST. variables within BY group processing to achieve this. Which of the following code snippets would correctly calculate the average of the top three highest scores for each student?

（A）data student_avg; set exam_scores; by student_id; retain top_scores 0 count 0; if firststudent_id then do; top_scores=0; count=0; end; if _ N <=3 then do; top_scores+score; count+l; end; output; run;

（B）data student_avg; set exam_scores; by student_id; retain top_scores 0 count 0; if firststudent_id then do; top_scores=0; count=0; end; if _ N <=3 then do; top_scores+score; count+l; end; output; run;

（C）data student_avg; set exam_scores; by student_id; retain top_scores 0 count 0; if firststudent_id then do; top_scores=0; count=0; end; if _ N <=3 then do; top_scores+score; count+l; end; avg_score=top_scores/count; output; run;

（D）data student_avg; set exam_scores; by student_id; retain top_scores 0 count 0; if firststudent_id then do; top_scores=0; count=0; end; array top_scores[3] _ temporary_; if _N <=3 then do; top_scores[_N_]=score; count+l; end; avg_score=sum(of top_scores[,])/count; output; run;

（E）data student_avg; set exam_scores; by student_id; retain top_scores 0 count 0; if firststudent_id then do; top_scores=0; count=0; end; if _ N <=3 then do; top_scores=score; count+l; end; avg_score=top_scores/count; output; run;

正解：D 解答を投票する

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

質問 4

You have a dataset called 'CustomerData' with variables 'Age' (numeric), 'Gender' (character), and 'PurchaseAmount' (numeric). You want to create a two-way frequency table showing the distribution of 'Age' by 'Gender', but only for customers whose 'PurchaseAmount' is greater than $100. Which code snippet would achieve this?

（A）

（B）

（C）

（D）

（E）

正解：C 解答を投票する

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

質問 5

Which of the following statements about global SAS statements are true? (Select all that apply)

（A）Global statements are defined using the 'global' keyword.

（B）Global statements can be used to set options, define macro variables, and declare formats.

（C）Global statements are specific to the current SAS program and are not accessible from other programs within the same SAS session.

（D）Global statements are processed only once, regardless of how many times they are encountered in a SAS sessiom

（E）Global statements are executed before any other SAS program code.

正解：B、D、E 解答を投票する

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

質問 6

You have a dataset containing customer names in a variable named 'CUSTOMER NAME'. Some names are in all uppercase, some are in all lowercase, and some have a mix of cases. You need to standardize all customer names to have the first letter in uppercase and the rest in lowercase. Which SAS code snippet accomplishes this task using the 'PROPCASE' function?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 7

You are working with a dataset containing a variable called 'SALES' with numeric values. You need to categorize the sales values into three groups: 'Low', 'Medium', and 'High' based on their ranges. Which code snippet correctly defines a custom format using PROC FORMAT and the VALUE statement to achieve this?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 8

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）PROC SORT DATA=CUSTOMERS OUT-CUSTOMERS SORTED, BY CITY DESCENDING, ZIP CODE, RUN,

（B）PROC SORT DATA=CUSTOMERS OUT-CUSTOMERS SORTED, BY CITY ASCENDING, ZIP CODE; RUN,

（C）PROC SORT DATA=CUSTOMERS OUT-CUSTOMERS SORTED, BY CITY, ZIP CODE DESCENDING; RUN,

（D）PROC SORT DATA=CUSTOMERS OUT-CUSTOMERS SORTED, BY ZIP CODE DESCENDING, CITY ASCENDING; RUN,

（E）PROC SORT DAT=CUSTOMERS OUT-CUSTOMERS SORTED, BY CITY, ZIP CODE, RUN,

正解：C 解答を投票する

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

質問 9

You are analyzing customer demographics data and want to create a frequency distribution report for the 'Age' variable, sorted by age group in ascending order. The 'Age' variable has values ranging from 18 to 80. Which PROC FREQ statement would achieve this?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 10

You are analyzing a dataset with variables 'CUSTOMER_NAME', 'ORDER DATE', and 'ORDER VALUE'. You need to create a new variable 'ORDER DAY' that extracts the day of the week from 'ORDER DATE' (e.g., 'Monday', 'Tuesday', etc.). Which of the following SAS code snippets will accomplish this task correctly?

（A）

（B）

（C）

（D）

（E）

正解：E 解答を投票する

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

質問 11

You have a SAS dataset 'TRANSACTIONS' with variables 'TRANSACTION D', 'CUSTOMER ID', 'PRODUCT ID', and 'AMOUNT'. You need to create a dataset 'CUSTOMER TRANSACTIONS containing the total amount spent by each customer. Additionally, you need to include a variable 'NUM TRANSACTIONS' that indicates the number of transactions made by each customer. Which code snippet would you use to achieve?

（A）

（B）

（C）

（D）

（E）

正解：E 解答を投票する

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

質問 12

You have three datasets: 'CUSTOMERS', 'ORDERS', and 'PRODUCTS'. 'CUSTOMERS has 'CUSTOMER ID' and 'CITY', 'ORDERS' has 'ORDER ID', 'CUSTOMER ID', and 'PRODUCT ID', and 'PRODUCTS' has 'PRODUCT ID' and 'PRICE'. You want to create a dataset 'SALES SUMMARY' that summarizes the total sales for each product in each city. How would you use multiple MERGE statements and the IN= option to achieve this?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 13

You have a dataset containing a variable 'PRICE' with values like 123.45, 25.87, 999.99, and 10.00. You want to create a new variable 'DISCOUNT PRICE by applying a discount of 10% to the 'PRICE variable and then rounding the discounted price to the nearest integer using both the ROUND and INT functions. Which code snippet achieves this correctly?

（A）

（B）

（C）

（D）

（E）

正解：A 解答を投票する

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

質問 14

You have two datasets, 'SALES' and 'CUSTOMER', both containing a common variable 'CUST ID'. You need to create a new dataset 'SALES WITH CUSTOMER INFO that includes all sales records from 'SALES' and corresponding customer information from 'CUSTOMER' based on 'CUST ID'. Which of the following MERGE statements will achieve this, assuming both datasets are sorted by 'CUST ID'?

（A）

（B）

（C）

（D）

（E）

正解：D 解答を投票する

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

質問 15

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'CITY', and 'STATE'. You want to create a new dataset 'NEW CUSTOMERS' containing only observations from the 'CUSTOMERS' dataset where the 'STATE' is either 'CA' or 'NY'. You also want to add a new variable called 'REGION' to the 'NEW CUSTOMERS dataset, assigning 'West' for CA customers and 'East' for NY customers. Which of the following DATA step code snippets will achieve this?

（A）

（B）

（C）

（D）

（E）

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

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

質問 16

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）