Looks like something you can do easily with normal SAS statements.
In this case the UPDATE statement. You want to update the dataset with product/price lists with the information from the dataset that also has quantity information.
data prices;
input Product $ Price :comma.;
cards;
A $3
B .
C $5
D $8
E .
;
data quantities ;
input Product $ Price :comma. Quantity;
cards;
A $3 1
B $10 2
E $12 4
;
data want;
update prices quantities;
by product;
run;
Result
You did not show any situations where the product was in both dataset, but in that case any non-missing value of price in the transaction dataset (the one with the quantity variable) would replace the price from the original dataset (the one only the product and price).
... View more
