Suppose there are two datasets called car and color: DATA car INPUT name $ year

Question

Suppose there are two datasets called car and color: DATA car INPUT name $ year make $ model $; CARDS Nathen 1989 Toyota Camry Logan 2003 Hyundai Sonata Brian 2000 Ford Mustang DATA color, INPUT name $ color $ CARDS; Nathen Silver Logan White Brian Red Judy Blaclk And the following is the output after run a SAS program: bs name year make 1 Brian 2000 FordMustang Red 2 Judy 3 Logan 2003 Hyundai Sonata White 4 Nathen 1989 Toyota Camry Silver model color Black Which statement between SET and MERGE is used?

Explanation / Answer

SET STATEMENT USED TO COMBINE DATA VERTICALLY

MERGE STATEMENT IS USED TO COMBINE DATA HORIZONTALLY

Here data is horizontal

So use merge statement

ANSWER:MERGE

CODE:

PROC SORT DATA=CAR;

BY NAME;

RUN;

PROC SORT DATA=COLOR;

BY NAME;

RUN;

DATA FINAL;

MERGE CAR COLOR;

BY NAME;

RUN;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.