summarizing with conditional output

[dona17]

Hi,

Can anyone please help me with the following :

I have data, where customers spending more than$100 is rewaded. I need to create 3 datasets(d1 d2 d3),the variable order_type indicates whether sale was retail(=1),catalog(=2),internet(=3).the variable total_retail_price is the amount the customer spends on each individual order. I need to create variable totsales to hold total sales to each customer by order_type.A customer can output to more than 1 dataset if he spents $100  or more in retail  and internet.

data s;
set blib.usorders04;
where total_retail_price>100;
run;
proc sort data=s out=s1;
by order_type;
run;
data d1 d2 d3;
set s1;
totsales=sum(total_retail_price);
by order_type;
if order_type=1 then output d1;
if order_type=2 then output d3;
if order_type=3 then output d3;
proc print data=d1;
run;

[PaigeMiller · Accepted solution]

Let's start with this part

I need to create 3 datasets(d1 d2 d3)

This makes the rest of your problem more difficult to code, and in fact is completely unnecessary (and a bad idea as well). Keep everything in one data set.

Now that we have skipped the unnecessary creation of separate data sets, you can do the summing very easily

proc summary data=blib.usorders04(where=(total_retail_price>100)) nway;
    class order_type customer;
    var total_retail_price;
    output out=want sum=total_sales;
run;

The output data set that I have named WANT has everything you need.

[archita]

thanks, it is working.