You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation…

Question

Options

• AAppend
• BExtract
• CLookup
• DMining Results

• A
  9% (2)
• B
  78% (18)
• C
  4% (1)
• D
  9% (2)

Explanation

Extract is correct because it is specifically designed to pull a subset of rows (and optionally columns) from a source table based on filter conditions - exactly what you need to filter customers where country = 'Italy' from a global customer table.

Why the distractors are wrong:

• A. Append combines rows from multiple tables into one; it adds data together rather than filtering it down.
• C. Lookup matches and enriches records by joining a source table against a reference/lookup table - it's for data enrichment, not subsetting.
• D. Mining Results is used to process or publish results from SAS Enterprise Miner models - entirely unrelated to simple row filtering.

Memory tip: Think of Extract like a strainer - you pour in the whole dataset and only the rows matching your criteria pass through. Whenever a question asks you to isolate a subset of rows based on a condition, Extract is your answer.

No community discussion yet for this question.