PROC SQL - Running sum/total for a range

[Tom]

---

@Ranny wrote:

Sorry to keep pushing on SQL, As the entire process is build in SQL (running in SAS) - some SQL programmer must have created this long back, as I am not allowed to change production job, I was assign to this to modify the task, so I would also like to keep the SQL query as it is and I agree with you, probably it is time for us to convert this process from SQL to SAS. I appreciate all of your help and support here. This is a great community.

---

Why does it matter if one step in the process is using a proc or a data step and other steps are using proc sql?

There is no need to convert the entire program. Unless the entire program is just this one step. And it that case there is really no need keep any PROC SQL code.

[SASKiwi]

This is exactly like being a house builder and being told you have to use a handsaw to cut your wood and not a power saw...it just doesn't make sense at all.