topic Re: Merge tables with duplicate id values in SAS Programming

Merge tables with duplicate id values

Ranjeeta — Mon, 11 May 2020 23:13:16 GMT

Hello,

I would appreciate some advice on how I can add or attach the two columns Service Detail 1 and Service Detail 2 from the vas_code_test dataset into the vas_1819_sum_test dataset

Thanks

Re: Merge tables with duplicate id values

RichardDeVen — Tue, 12 May 2020 01:41:30 GMT

The SUM_TEST invtervention code 1KY76 matches 5 different CODE_TEST rows on KCCI_CODE_new, each having different ServiceDetails.

What do you want added to SUM_TEST ?

5 new rows for each CODE_TEST with 1KY76 ?
The Service Details from the first CODE_TEST row?
10 new columns ? Ie. the Details1&2 from each of the CODE_TEST rows ?

Re: Merge tables with duplicate id values

Kurt_Bremser — Tue, 12 May 2020 05:54:58 GMT

The HOW is a function of the WHAT. You have not told us what you expect to get, so we can't tell you how to be about it.

Re: Merge tables with duplicate id values

Ranjeeta — Tue, 12 May 2020 15:32:47 GMT

I woanted option 3 but i will close this track now as there is some info missing from the business side