Hi, I am having the hardest time trying to figure out the SAS code to do the following: Assume I have two datasets (A) and (B) (A) Product Price A $3 B   C $5 D $8 E     (B) Product Price Quantity A $3 1 B $10 2 E $12 4   I would like to left join (A) with (B) to get quantity (when it is available) and if price is missing in (A) then I would like to take the price from (B). So, the dataset I would like to end up with looks like this:   (C) Product Price Quantity A $3 1 B $10 2 C $5   D $8   E $12 4   Thanks in advance!     ... View more