Merging Data

[Trent Claybaugh]

Hello all,

I have two datasets: one has a column of geographic identifiers and one has a column of geographic identifiers and a column of dates.

I am trying to create a dataset that will append every date from the second dataset to the corresponding row (with a matching geographic identifier) in the first dataset. There are multiple dates in the second dataset that correspond to each geographic identifier in the first dataset. I would like to create a unique row for each geographic identifier -- date combination. The final product should look something like this:

GEOID --- DATE

1 ............. Date 1
1 ............. Date 2
1 ............. Date 3

I am not sure how to do this. Does somebody have any idea?

Thank you!

[Clyde Schechter]

use geo_identifier_data_set
merge 1:m geoid using geo_identifier_plus_dates_dataset