Merging datasets with repeated variables

[Phil_from_PGA]

Hello, I'm using SAS University edition / SAS studio.

I have two datasets with three variables item ID; quantity and price. The first data set has item ID and a unique quantity for that item. The second data set has item ID and price for that item - but the item ID and (same) price appear several repeated times.  

I just want a merged data set that has: item ID, quantity and one (same) price as the columns. How do I do this?

For example, see the code below:

/* Create sample data */
data one;
 input id $ quantity $;
 datalines;
Item_a 4
Item_b 3
Item_c 2;

data two;
 input id $ price $;
 datalines;
Item_a 1.10
Item_a 1.10
Item_b 2.35
Item_b 2.35
Item_c 5.50
Item_c 5.50
Item_c 5.50;

data both;
 merge one (in=in1) two (in=in2);
 by id;

 if in1=1 and in2=1;
run;

proc print data=both;
run;

[Reeza · Accepted solution]

Why does the second data set have duplicates? I would remove the duplicates and then merge. Your data step code will work. You can remove duplicates with proc sort and noduprecs or nodupkey. 

[Phil_from_PGA]

Thanks - that worked well.