SQL SIMPLE QUENSTION .. SBD HELP ME!

[AmeeKang]

This is a table A and B.

I want to create the following result by using SQL with the KEY value of the DTGBN column.

some body help me!!!!

[PaigeMiller]

Please explain the logic used here to give the desired result to be 100+300+50+70-20

How do you get that from the original data, what is the logic?

What does table B have to do with this problem?

[mkeintz]

How do you know that you are supposed to:

1. Add the four RFAMT entries in blue cells (100+300+50+70)
2. Subtract the RFAMT in yellow (-20)
3. Ignore the RFAMT in the white cell (970000090)

Why do you refer to the DTBIN column as a key?

[andreas_lds]

Just guessing:

• DTGBN: T = addition, M = substraction
• table_b.accno must match either table_a.iacno or table_a.oacno

Right?

Drop the idea of using sql, data step is most likely better readable an far easier to code.

Until you post the data in usable form (data steps with datalines) i can't suggest any code.

[andreas_lds]

Another thing you need to tell us: what exactly do you expect as output? A dataset, a table, a line in the log? How should it look like?