Dataset is simple, Brand, Brand2, and value, so it looks something like this: Brand Brand2 Amount A B -5 A C -7 B A -10 etc I want to add two variables to the dataset, one is simply the absolute value of AMOUNT for that record. The tricky one is that I need another variable, call it REVERSE, that would be the AMOUNT of the opposite brands, so for the first record, Brand =A and Brand2=B, I want REVERSE to grab the value of the record where Brand=B and Brand2=A (reverse value of the brands chosen). So the first record would be Brand=A Brand2=B AMOUNT=-5 ABSAMT=5 and REVERSE=-10 I have it like this, but I don't know how to get the REVERSE to work proc sql; create table brand12 as select a.brand,a.brand2, abs(a.amount) as absamt, sum(amount) having (a.brand=b.brand2 and a.brand2=b.brand) as reverse from main_data a ,main_data b; quit; I've tried the reverse a couple different ways, but none have worked. That is the last one I tried, but I think this is simple. Any help on syntax would be apprecitated. Thanks!
... View more