nerdexam
SAS_Institute

A00-201 · Question #89

A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,""$54,000"" SPLIT,1190,4,1,Rand Street,""$95,850"" CONDO,11400,2,1,3,Market Street,""$80,050"" TWOSTORY,1800,4,3,Gerris…

The correct answer is B. 3. See the full explanation below for the reasoning.

Question

A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,""$54,000"" SPLIT,1190,4,1,Rand Street,""$95,850"" CONDO,11400,2,1,3,Market Street,""$80,050"" TWOSTORY,1800,4,3,Gerris Street,""$107,250"" RANCH,1500,3,3,Kemble Avenue,""$86,650"" SPLIT,1615,4,3,West Drive,""$94,450"" SPLIT,1305,3,1,5,Graham Avenue,""$73,650"" The following SAS program is submitted using the raw data file as input: data work.condo_ranch; infile 'file-specification' dsd; input style $ @; if style = 'CONDO' or style = 'RANCH'; input sqfeet bedrooms baths street $ price : dollar10.; run; How many observations will the output data set contain?

Options

  • A0
  • B3
  • C5
  • D7

How the community answered

(45 responses)
  • A
    7% (3)
  • B
    78% (35)
  • C
    4% (2)
  • D
    11% (5)

Community Discussion

No community discussion yet for this question.

Full A00-201 Practice