View All num of num See all Photos Progressive Insurance This employer has taken extra steps to respond to reviews and provide job seekers with accurate company information, photos, and reviews. Interested for your company?Learn More. www.progressive.com www.progressive.com Work in HR? Unlock Free Profile Overview Reviews Salaries Interviews Jobs Photos Benefits 742 Reviews 1.6k Salaries 435 Interviews 149 Jobs Follow Add Review or Salary Follow Add Review or Salary Progressive Insurance 742 Interview Question Data Analyst Interview Progressive Insurance how to merge two data sets by sql or data steps Tags: See more , See less 8 Answer Add Tags Flag as Inappropriate Thank you! Your feedback has been sent to the team and we'll look into it. Oops! We're sorry but your feedback didn't make it to the team. Your input is valuable to us — would you mind trying again? Send Answer Interview Answer 1 Answer ▲ 0 ▼ In SQL, you can use JOIN and UNION or UNION ALL to merge tables. Since the question is about DataSets, it may be related to the .NET data representation model described in ADO.NET. DataSet in .NET has a Merge method, which allows it to merge two datasets into one.When dealing with large aggregations of data, merging two datasets may not alwatys be such a great idea, as the memory footprint of your operation becomes much bigger. On the other hand, if you are trying to repetitively select data from the two datasets, and performance is an issue, then merging them may indeed be the answer. Anonymous on May 10, 2010 Flag as Inappropriate Thank you! Your feedback has been sent to the team and we'll look into it. Oops! We're sorry but your feedback didn't make it to the team. Your input is valuable to us — would you mind trying again? Send Add Answers or Comments To comment on this, Sign In or Sign Up.