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

質問 1

You have a SAS dataset named 'customer info' that contains detailed customer information. You need to export this data to an Excel file with specific formatting, including column widths, data types, and header labels. Which of the following code snippets correctly utilizes the LIBNAME statement and XLSX engine to achieve this objective?

（A）

（B）

（C）

（D）

（E）

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

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

質問 2

You have a SAS dataset named 'TRANSACTIONS' with variables 'TRANSACTION D', 'PRODUCT ID', 'CUSTOMER ID', 'AMOUNT', and 'DATE'. You need to create a new dataset called 'HIGH TRANSACTIONS' containing only transactions with amounts greater than $1000, but only if the transaction occurred in the last three months. Which code snippet will achieve this?

（A）

（B）

（C）

（D）

（E）

正解：D 解答を投票する

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

質問 3

You are running a SAS program that reads data from a file and performs calculations. The following error message appears in the SAS log:

Which of the following is the most likely cause of this error, and where would you look in your code to find the issue?

（A）A missing quotation mark in a character variable assignment.

（B）A missing semicolon at the end of a statement within the DATA step.

（C）A missing comma separating variables in the INPUT statement

（D）A missing closing parenthesis in a function call.

（E）An incorrect variable name in the INPUT statement

正解：B 解答を投票する

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

質問 4

You are working with a SAS dataset named 'SALES containing information about sales transactions. The dataset has a variable 'PRODUCT ID' and 'QUANTITY SOLD'. You want to create a new dataset 'SALES SUMMARY' that summarizes the total quantity sold for each product. Which code snippet would you use to achieve this?

（A）

（B）

（C）

（D）

（E）

正解：C 解答を投票する

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

質問 5

You are working with a dataset containing sales transactions. You need to create a summary table that shows the total sales for each quarter of the year. Which code snippet would you use to achieve this, incorporating the OUTPUT statement to control output timing?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 6

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 メンバーにのみ表示されます)

質問 7

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）

（B）

（C）

（D）

（E）

正解：A 解答を投票する

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

質問 8

Consider the following DATA step code:

Which of the following statements are TRUE about the LENGTH statement in this context?

（A）The LENGTH statement is not used explicitly in this code, so the default length of 8 characters is assigned to the 'name' variable.

（B）The LENGTH statement is used to explicitly define the length of the 'age' variable, even though it is not mentioned in the code.

（C）The LENGTH statement is not used explicitly in this code, and the 'name' variable is assigned the default length of 200 characters because it is a character variable.

（D）The LENGTH statement is implicitly used to define the length of the 'name' variable as 10 characters.

（E）The LENGTH statement is not used explicitly in this code, but the 'name' variable still inherits the length of 10 characters from the INPUT statement.

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

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

質問 9

You are building an interactive dashboard that displays sales data from a SAS dataset. The dashboard needs to be generated as an HTML file that includes interactive charts and tables. Which of the following methods can be used to achieve this using ODS?

（A）Use the mods html' statement with the option and specify the path to an HTML file.

（B）Use the 'ods html' statement with the "file=' option and a third-party library to add interactivity to the generated HTML file.

（C）Use the 'ods html' statement with the 'style=' option to define the style and the 'file=' option to specify the output path.

（D）Use the 'ods html' statement with the 'style:' option to define the interactive elements in the HTML file.

（E）Use the 'ods html' statement to generate an HTML file and then use a third-party library to add interactivity.

正解：B 解答を投票する

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

質問 10

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?

（A）The macro variable &MACRO VAR was defined within the macro, but its value was not correctly assigned.

（B）The macro variable &MACRO_VAR was defined outside of the macro, but it was not passed as a parameter to the macro.

（C）The macro variable &MACRO VAR is not a valid SAS macro variable name.

（D）The macro variable &MACRO_VAR was not properly defined within the macro.

（E）The macro variable &MACRO VAR was defined within the macro, but it was not referenced correctly within the macro code.

正解：D 解答を投票する

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

質問 11

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）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 12

You have a SAS dataset called 'EMPLOYEES' with variables 'EMPLOYEE ID', 'FIRST NAME', 'LAST NAME', 'DEPARTMENT', 'SALARY, 'HIRE DATE'. You need to create a new dataset called 'EMPLOYEES HIGH SALARY' containing only employees with salaries greater than $100,000, and you want to rename the 'SALARY' variable to 'HIGH SALARY'. Which code snippet correctly achieves this?

（A）

（B）

（C）

（D）

（E）

正解：B 解答を投票する

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

質問 13

You have a CSV file named 'sales_data.csv' with the following structure: Product,Region,Sales Apple,North, 100 Banana,South,200 You need to import this data into a SAS dataset named 'SalesData' and ensure that the 'Sales' column is numeric. Which code snippet achieves this correctly?

（A）

（B）

（C）

（D）

（E）

正解：E 解答を投票する

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

質問 14

You are tasked with developing a SAS program to analyze customer demographics. The program reads data from a CSV file and performs several calculations. You compile the program and encounter the following error message: ' 'ERROR 180-322: Statement is not valid or it is used out of context. '' What type of error is this, and what specific aspect of the PUTLOG statement would be most helpful in resolving this issue?

（A）Logic error; use PUTLOG to print the value of variables involved in the calculation.

（B）Syntax error; use PUTLOG to print the entire SAS program's code.

（C）Logic error; use PUTLOG to print the line number and the contents of the problematic statement.

（D）Logic error; use PUTLOG to print the contents of the input CSV file.

（E）Syntax error; use PUTLOG to print the line number of the statement causing the error.

正解：E 解答を投票する

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

質問 15

You want to read a SAS data set named 'CUSTOMERS' and update a variable 'Age' based on the following logic: If the 'Age' is missing, set it to the average age of all customers. Otherwise, leave the 'Age' unchanged. Which SAS code snippet correctly implements this logic?

（A）

（B）

（C）

（D）

（E）

正解：D 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験