Multiple choice technology programming languages

What is the output of : data merged; merge fltsuper fltdest; by flight; run; proc print data=merged noobs; title ’Table MERGED’; run; FLTSUPER Flight Supervisor 145 Kang 145 Ramirez 150 Miller 150 Picard 155 Evanko 157 Lei FLTDEST Flight Destination 145 Brussels 145 Edmonton 150 Paris 150 Madrid 165 Seattle

  1. Table MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris 155 Evanko 157 Lei 165 Seattle

  2. Table MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris

  3. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid

  4. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid 155 Evanko 157 Lei 165 Seattle
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The MERGE statement in SAS combines datasets by matching the BY variable (flight). FLTSUPER has 6 flights (145,145,150,150,155,157) and FLTDEST has 5 flights (145,145,150,150,165). MERGE matches all occurrences: 145 matches both rows, 150 matches both rows, while 155, 157 appear only in FLTSUPER, and 165 appears only in FLTDEST. The result contains all observations from both datasets. Option D shows all 7 rows correctly.

Keep practicing — related questions