topic Re: Summation in SAS Programming

Summation

Raj21 — Mon, 25 Jul 2016 20:52:16 GMT

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!

Re: Summation

LinusH — Mon, 25 Jul 2016 21:18:13 GMT

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

Re: Summation

PGStats — Mon, 25 Jul 2016 21:47:22 GMT

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;

Re: Summation

Raj21 — Tue, 26 Jul 2016 03:56:13 GMT

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