I have a dataset with unique id's. I know there are multiple instances in the 2nd table of each id. I would like to do a loop where I go through each ID in Dataset A, Find records matching records in Dataset B, and append that data to the same row for that particular ID, in a new dataset that I created, where each set of dates found in Dataset B can be appended in one row of Dataset C. I would need to incorporate a data step and a proc sql step together, but not sure how do this. I want to create a dataset that has ID, statedate1, enddate1, startdate2, enddates2, etc... thank you in advance
... View more