Performing a One to Many Merge The pg 2 np 2 0 1 6 traffic table contains monthly traffic statistics from the National Park Service for parks Create a table that contains the monthly traffic statistics from the pg 2 np 2 0 1 6 traffic table and adds a column for the park name Park name values can be found in the matching pg 2 np codelookup table a Open the p 2 0 5 p 0 3 sas program in the practices folder Submit the two PROC SORT steps Determine the name of the common column in the sorted tables b Modify the second PROC SORT step to use the RENAME option after the pg 2 np 2 0 1 6 traffic table to rename Code to ParkCode Modify the BY statement to sort by the new column name Note You could also rename the column in the DATA step after the table in the MERGE statement c Write a DATA step to merge the sorted tables by the common column to create a new table, work trafficStats Drop the Name Code column from the output table table , A ParkCode,Year, ( 1 2 ) Month, ( 2 3 ) MonthCount,ParkName, Region,Type , 1 , ABLI, 2 0 1 6 , 1 , 2 , 1 5 9 , Abraham Lincoln Birt ,Southeast,National Histori , 2 , ABLI, 2 0 1 6 , 2 , 2 0 5 7 , Abraham Lincoln Birt ,Southeast,National Histori , 3 , ABLI, 2 0 1 6 , 3 , 4 6 3 0 , Abraham Lincoln Birt ,Southeast,National Histori , 4 , ABLI, 2 0 1 6 , 4 , 6 6 0 2 , Abraham Lincoln Birt ,Southeast,National Histori , 5 , ABLI, 2 0 1 6 , 5 , 6 4 5 9 , Abraham Lincoln Birt ,Southeast,National Histori , 6 , ABLI, 2 0 1 6 , 6 , 7 7 3 9 , Abraham Lincoln Birt ,Southeast,National Histori , 7 , ABLI, 2 0 1 6 , 7 , 1 4 , 0 1 6 , Abraham Lincoln Birt ,Southeast,National Histori , 8 , ) , 2 0 1 6 , 8 , 1 0 2 2 7 , Dhraham lincoln Birt,Southeast,National Histori

The Answer is in the image, click to view ...

Question: Performing a One - to - Many Merge The pg 2 . np _ 2 0 1 6 traffic table contains monthly traffic statistics from

Performing a One

-

-

Many Merge

The pg

2 .

_2016

traffic table contains monthly traffic statistics from the National Park Service for parks. Create a table that contains the monthly traffic statistics from the pg

2 .

_2016

traffic table and adds a column for the park name. Park name values can be found in the matching pg

2 .

_

codelookup table.

.

Open the p

205

03 .

sas program in the practices folder. Submit the two PROC SORT steps. Determine the name of the common column in the sorted tables.

.

Modify the second PROC SORT step to use the RENAME

=

option after the pg

2 .

_2016

traffic table to rename Code to ParkCode. Modify the BY statement to sort by the new column name.

Note: You could also rename the column in the DATA step after the table in the MERGE statement.

.

Write a DATA step to merge the sorted tables by the common column to create a new table, work.trafficStats. Drop the Name

_

Code column from the output table.

\

table

[[,

A ParkCode,Year,

(12)

Month,

(23)

MonthCount,ParkName,

Region,Type

], [1,

ABLI,

2016, 1, 2, 159,