How group merge duplicate rows using PROC SQL

sufiya — Thu, 08 Mar 2018 17:27:32 GMT

Hi,

Would anyone know how to, by using PROC SQL merge duplicate variables rows and this would result in a sum up of one column?

tried SELECT DISTINCT and GROUP BY but I am still receiving multiple duplicates.

4 duplicate rows showing for each Product #... if I do PROC SORT nodupkey then it will remove all but 1 and the amount for Jan will not be correct...

please HELP

this is what I am getting

but what I want is

Re: How group merge duplicate rows using PROC SQL

ballardw — Thu, 08 Mar 2018 18:34:41 GMT

I would look at steps prior and ensure that the duplicates aren't made. Likely doing the sum before the "merge" might help.

PGStats — Thu, 08 Mar 2018 20:39:13 GMT

Please make us a small example with input data and code.