Hi and welcolme to the SAS communities forum.
In order to debug this you need to gradually increment the complexity.
By posting appropriate test data you will increase your chances to get an answer that suits your needs.
I do not understand right now how you can start with
sdjisdjis|233 |0 |
look in the separate libraries that do NOT contain the id
sdjisdjis
|Limit_ref|Off_ballance_exposure|
3dssdasdda| 4343|
3dssdasdda| 7777|
dfdfdfdfdf| 488.12|
dfdfdfdfdf| 8.10 |
and expect to get a sum of 344!!
sdjisdjis|233 | 344|
sdjisdjis|234 | 0 |
sdjisdjis|235 | 0 |
Please format your post in a more readable manner.
Please post some test data you have and the results you'd expect
... View more