nerdexam
SAS_Institute

A00-212 · Question #177

A data set stored on a network drive has the following characteristics: 14 Million observations 400 numeric variables 0 character variables of length 20 Binary compression A DATA Step query requires…

The correct answer is D. A DROP= data set option used on the DATA Statement. See the full explanation below for the reasoning.

Question

A data set stored on a network drive has the following characteristics:

14 Million observations 400 numeric variables 0 character variables of length 20 Binary compression A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?

Options

  • AA KEEP= data set option used on the SET Statement
  • BA KEEP Statement used within the DATA Step
  • CA KEEP= data set option used on the DATA Statement
  • DA DROP= data set option used on the DATA Statement

How the community answered

(38 responses)
  • A
    11% (4)
  • B
    3% (1)
  • C
    5% (2)
  • D
    82% (31)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice