topic Re: Data step to look at different values in SAS Enterprise Guide

Data step to look at different values

paul2877 — Thu, 08 Oct 2015 20:50:31 GMT

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.

Re: Data step to look at different values

Reeza — Thu, 08 Oct 2015 20:59:44 GMT

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

Re: Data step to look at different values

Astounding — Thu, 08 Oct 2015 22:39:16 GMT

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.