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

A00-211 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?

Show Answer
Correct Answer: BD

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

3 comments
Sign in to comment
mhminkovOption: B
Jun 4, 2021

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.

Kleinstone
Jan 10, 2021

repeat as Q.91

KleinstoneOption: B
Jan 10, 2021

the same as Q90