Hi everyone, I'm new to SAS and I need help. I have 2 datasets, ALL FRUIT and BANANAS ONLY. I want to add a column to ALL FRUIT (BANANA PACKAGE) that will match in the BANANAS ONLY dataset. I want the BANANA PACKAGE column be blank if the Sales Type = Only or if Fruit = Banana otherwise "Yes". Basicaly I want to find out when bananas were sold with other fruit. Can someone help me with this? ALL FRUIT Customer_No Fruit Amount Sale_Type 100 Banana 5 Package 100 Apple 2 Package 100 Orange 3 Package 200 Banana 5 Only 300 Apple 2 Package 300 Orange 3 Package 400 Banana 5 Package 400 Apple 2 Package 400 Orange 3 Package 500 Banana 5 Package 500 Apple 2 Package 500 Orange 3 Package 600 Apple 2 Only 700 Orange 3 Only 800 Apple 2 Package 800 Banana 5 Package 900 Banana 5 Only 1000 Banana 5 Package 1000 Orange 3 Package BANANAS ONLY Customer_No Fruit Amount Sale_Type 100 Banana 5 Package 200 Banana 5 Only 400 Banana 5 Package 500 Banana 5 Package 800 Banana 5 Package 900 Banana 5 Only 1000 Banana 5 Package
... View more