The narrative is I am running a waterfall if-else conditions tagging along as exclusions and I wanted to show the waterfall report and each condition with the min and max of the variable involved in the logic ... View more

It would help a lot if you could provide some representative sample mock-up data (via a SAS data step) and then also show us how the desired result using this sample data should look like. Providing sample data and desired result not only reduces ambiguity, it also allows us to provide tested code as answer.  ... View more

No. SQL can't do it due to don't know how many hierarchy/strata it is . How big size of your table is it ? ... View more