Exam A00-211 All QuestionsBrowse all questions from this exam
Go to Exam
Question 49

A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"

SPLIT,1190,1,1,Rand Street,"$65,850"

CONDO,1400,2,1.5,Market Street,"80,050"

TWOSTORY,1810,4,3,Garris 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' then input sqfeet bedrooms baths street $ price : dollar10.; run;

How many observations does the WORK.CONDO_RANCH data set contain?

    Correct Answer: B

    The SAS code reads the data file and checks if the style is either 'CONDO' or 'RANCH'. If this condition is met, it reads the remaining values (sqfeet, bedrooms, baths, street, and price). From the provided data, the entries that meet this condition are: 'CONDO' and 'RANCH'. There are three such entries: the entries for 'CONDO' on Market Street and 'RANCH' on Sheppard Avenue and Kemble Avenue. Therefore, the WORK.CONDO_RANCH data set contains 3 observations.

Discussion
mhminkovOption: B

no, not the same as Q90 Q90: input style $ @; if style = 'CONDO' or style = 'RANCH'; input ... Q91: input style $ @; if style = 'CONDO' or style = 'RANCH' then input ... In both Questions correct answer is given.

KleinstoneOption: B

the same as Q90

Kleinstone

repeat as Q.91