Summation

[Raj21]

I want to collapse dollars by summing by a specific variable.  Every column in these two observations is the exact same except the PYMT_AMT_DLR.  I would like to get that load to add up together then i can can sum by TRIP later and eventually do a comparison. 

LD_LEG_ID	TRIP_ID	PYMNT_AMT_DLR
10790980	349314	144.00
10790981	349314	-24.04
10790981	349314	144.00

Any help would be appreciated!

[LinusH]

Not sure what you want, a straight summary?
Can be done in tons of ways : SQL, PROC SUMMARY, even the data step...

[PGStats · Accepted solution]

proc SQL is most flexible for this kind of task:

proc sql;
create table by_Ld_Leg as
select 
	TRIP_ID, 
	LD_LEG_ID,
	sum(PYMNT_AMT_DLR) as sum_by_leg
from myData
group by TRIP_ID, LD_LEG_ID;
/* Later ... */
create table byTrip as
select
	TRIP_ID,
	sum(sum_by_leg) as sum_by_trip
from by_Ld_Leg
group by TRIP_ID;
quit;

[Raj21]

This worked exactly the way that I wanted, thank you!