Data step to look at different values

[paul2877]

Customer	Product	amount
Paul	apple	2
Paul	banana	5
Paul	apple	3
James	banana	2
James	grape	5
James	banana	3

Here is the table I have.. I have tried to simplify the questions so you understand what i am doing. Trying to create a data step that sums up all the products of apple.. if apple is not in the list for paul then return the banana amount.

[Reeza]

If you're in EG have you tried the summarize task?
Add customer/product to the Classification variables and amount to the analysis variable

[Astounding]

Here's one approach ... note that these are tools you will need to master in the long run.

proc summary data=have nway;

   var amount;

   class customer product;

   where product in ('apple', 'banana');

   output out=totals (keep=customer product amount) sum=;

run;

data want;

   set totals;

   by customer;

   if last.customer;

run;

Note that the data set TOTALS will automatically be in order BY CUSTOMER PRODUCT.  So if "banana" is there, it will be the last one for a CUSTOMER.  If not, "apple" will be the last one.

Good luck.